Overview
Brought to you by YData
Dataset statistics
| Number of variables | 35 |
|---|---|
| Number of observations | 2568724 |
| Missing cells | 14872 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 14914 |
| Duplicate rows (%) | 0.6% |
| Total size in memory | 2.1 GiB |
| Average record size in memory | 861.6 B |
Variable types
| DateTime | 1 |
|---|---|
| Numeric | 23 |
| Text | 6 |
| Categorical | 5 |
| Dataset has 14914 (0.6%) duplicate rows | Duplicates |
GINI is highly overall correlated with ingreso_laboral_promedio and 1 other fields | High correlation |
IPUG is highly overall correlated with edad_promedio and 2 other fields | High correlation |
ajustada_alineacion is highly overall correlated with alineación con portafolio estratégico and 2 other fields | High correlation |
alineación con portafolio estratégico is highly overall correlated with ajustada_alineacion and 2 other fields | High correlation |
cantidad is highly overall correlated with log_cantidad and 2 other fields | High correlation |
cantidad_promedio is highly overall correlated with precio_promedio and 3 other fields | High correlation |
categoria is highly overall correlated with categoria_macro | High correlation |
categoria_macro is highly overall correlated with categoria | High correlation |
edad_promedio is highly overall correlated with IPUG and 2 other fields | High correlation |
id is highly overall correlated with num_pedidos and 1 other fields | High correlation |
ingreso_laboral_promedio is highly overall correlated with GINI and 4 other fields | High correlation |
log_cantidad is highly overall correlated with cantidad and 2 other fields | High correlation |
log_precio is highly overall correlated with cantidad and 2 other fields | High correlation |
log_valor is highly overall correlated with ajustada_alineacion and 2 other fields | High correlation |
num_pedidos is highly overall correlated with id and 2 other fields | High correlation |
pedido is highly overall correlated with id | High correlation |
porcentaje_urbano is highly overall correlated with ingreso_laboral_promedio and 1 other fields | High correlation |
precio is highly overall correlated with cantidad and 2 other fields | High correlation |
precio_promedio is highly overall correlated with cantidad_promedio and 1 other fields | High correlation |
ticket_promedio is highly overall correlated with cantidad_promedio and 2 other fields | High correlation |
total_gasto is highly overall correlated with cantidad_promedio and 3 other fields | High correlation |
total_productos is highly overall correlated with cantidad_promedio and 4 other fields | High correlation |
valor is highly overall correlated with ajustada_alineacion and 2 other fields | High correlation |
zona is highly overall correlated with GINI and 4 other fields | High correlation |
cantidad is highly skewed (γ1 = 407.6718452) | Skewed |
precio is highly skewed (γ1 = 75.64533226) | Skewed |
valor is highly skewed (γ1 = 88.62689348) | Skewed |
alineación con portafolio estratégico is highly skewed (γ1 = -638.3338094) | Skewed |
ajustada_alineacion is highly skewed (γ1 = -164.0441718) | Skewed |
total_productos is highly skewed (γ1 = 23.56907809) | Skewed |
precio_promedio is highly skewed (γ1 = 24.84345157) | Skewed |
cantidad_promedio is highly skewed (γ1 = 73.01971405) | Skewed |
Total de edificaciones en obra has 678206 (26.4%) zeros | Zeros |
Reproduction
| Analysis started | 2025-04-06 05:45:04.610792 |
|---|---|
| Analysis finished | 2025-04-06 05:55:19.622739 |
| Duration | 10 minutes and 15.01 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
fecha
Date
| Distinct | 756 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.6 MiB |
| Minimum | 1971-01-02 00:00:00 |
|---|---|
| Maximum | 1973-01-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
pedido
Real number (ℝ)
High correlation 
| Distinct | 933814 |
|---|---|
| Distinct (%) | 36.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 466252.12 |
| Minimum | 2 |
|---|---|
| Maximum | 933936 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 46643.15 |
| Q1 | 230870 |
| median | 465819 |
| Q3 | 701243 |
| 95-th percentile | 887652 |
| Maximum | 933936 |
| Range | 933934 |
| Interquartile range (IQR) | 470373 |
Descriptive statistics
| Standard deviation | 270294.22 |
|---|---|
| Coefficient of variation (CV) | 0.57971688 |
| Kurtosis | -1.2057948 |
| Mean | 466252.12 |
| Median Absolute Deviation (MAD) | 235227 |
| Skewness | 0.0035068703 |
| Sum | 1.197673 × 1012 |
| Variance | 7.3058966 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 589388 | 152 | < 0.1% |
| 431390 | 136 | < 0.1% |
| 47364 | 114 | < 0.1% |
| 679361 | 111 | < 0.1% |
| 918192 | 108 | < 0.1% |
| 17776 | 108 | < 0.1% |
| 488822 | 108 | < 0.1% |
| 918218 | 108 | < 0.1% |
| 607844 | 104 | < 0.1% |
| 573522 | 104 | < 0.1% |
| Other values (933804) | 2567571 |
| Value | Count | Frequency (%) |
| 2 | 1 | < 0.1% |
| 3 | 4 | |
| 4 | 4 | |
| 5 | 4 | |
| 6 | 2 | < 0.1% |
| 7 | 8 | |
| 8 | 2 | < 0.1% |
| 9 | 4 | |
| 10 | 1 | < 0.1% |
| 11 | 4 |
| Value | Count | Frequency (%) |
| 933936 | 2 | |
| 933935 | 1 | < 0.1% |
| 933934 | 1 | < 0.1% |
| 933933 | 3 | |
| 933932 | 1 | < 0.1% |
| 933931 | 1 | < 0.1% |
| 933930 | 1 | < 0.1% |
| 933929 | 2 | |
| 933928 | 2 | |
| 933927 | 4 |
id
Real number (ℝ)
High correlation 
| Distinct | 419222 |
|---|---|
| Distinct (%) | 16.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 165617.2 |
| Minimum | 1 |
|---|---|
| Maximum | 419226 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9362 |
| Q1 | 58899 |
| median | 138026 |
| Q3 | 261522 |
| 95-th percentile | 384302 |
| Maximum | 419226 |
| Range | 419225 |
| Interquartile range (IQR) | 202623 |
Descriptive statistics
| Standard deviation | 121181.67 |
|---|---|
| Coefficient of variation (CV) | 0.73169737 |
| Kurtosis | -1.0227461 |
| Mean | 165617.2 |
| Median Absolute Deviation (MAD) | 94513 |
| Skewness | 0.45437008 |
| Sum | 4.2542488 × 1011 |
| Variance | 1.4684998 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3037 | 1735 | 0.1% |
| 1236 | 1671 | 0.1% |
| 2906 | 1555 | 0.1% |
| 3121 | 1361 | 0.1% |
| 3357 | 1318 | 0.1% |
| 2412 | 1173 | < 0.1% |
| 30822 | 998 | < 0.1% |
| 4206 | 945 | < 0.1% |
| 28478 | 756 | < 0.1% |
| 512 | 644 | < 0.1% |
| Other values (419212) | 2556568 |
| Value | Count | Frequency (%) |
| 1 | 85 | |
| 2 | 18 | < 0.1% |
| 3 | 4 | < 0.1% |
| 4 | 4 | < 0.1% |
| 5 | 20 | < 0.1% |
| 6 | 36 | < 0.1% |
| 7 | 20 | < 0.1% |
| 8 | 18 | < 0.1% |
| 9 | 92 | |
| 10 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 419226 | 2 | < 0.1% |
| 419225 | 1 | < 0.1% |
| 419224 | 1 | < 0.1% |
| 419223 | 1 | < 0.1% |
| 419222 | 1 | < 0.1% |
| 419221 | 11 | |
| 419220 | 8 | |
| 419219 | 1 | < 0.1% |
| 419218 | 6 | |
| 419217 | 2 | < 0.1% |
edad
Real number (ℝ)
| Distinct | 50 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.752713 |
| Minimum | 18 |
|---|---|
| Maximum | 67 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 18 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 31 |
| median | 43 |
| Q3 | 48 |
| 95-th percentile | 58 |
| Maximum | 67 |
| Range | 49 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 9.5305458 |
|---|---|
| Coefficient of variation (CV) | 0.22826172 |
| Kurtosis | -0.91711203 |
| Mean | 41.752713 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.17876145 |
| Sum | 1.072512 × 108 |
| Variance | 90.831304 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 31 | 402001 | 15.6% |
| 45 | 154275 | 6.0% |
| 43 | 151451 | 5.9% |
| 47 | 110215 | 4.3% |
| 41 | 108391 | 4.2% |
| 40 | 95676 | 3.7% |
| 50 | 91581 | 3.6% |
| 30 | 91125 | 3.5% |
| 46 | 88733 | 3.5% |
| 42 | 86804 | 3.4% |
| Other values (40) | 1188472 |
| Value | Count | Frequency (%) |
| 18 | 11 | < 0.1% |
| 19 | 240 | < 0.1% |
| 20 | 234 | < 0.1% |
| 21 | 575 | < 0.1% |
| 22 | 4635 | 0.2% |
| 23 | 9742 | 0.4% |
| 24 | 6819 | 0.3% |
| 25 | 10180 | 0.4% |
| 26 | 17266 | |
| 27 | 25943 |
| Value | Count | Frequency (%) |
| 67 | 466 | < 0.1% |
| 66 | 22 | < 0.1% |
| 65 | 90 | < 0.1% |
| 64 | 21378 | 0.8% |
| 63 | 2448 | 0.1% |
| 62 | 7280 | 0.3% |
| 61 | 5786 | 0.2% |
| 60 | 33558 | |
| 59 | 31561 | |
| 58 | 57713 |
municipio
Text
| Distinct | 807 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.9 MiB |
Length
| Max length | 27 |
|---|---|
| Median length | 26 |
| Mean length | 8.5339153 |
| Min length | 3 |
Unique
| Unique | 31 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | EL CARMEN DE CHUCURI |
|---|---|
| 2nd row | VILLANUEVA |
| 3rd row | VILLANUEVA |
| 4th row | VILLANUEVA |
| 5th row | VILLANUEVA |
| Value | Count | Frequency (%) |
| curiti | 575851 | |
| villanueva | 569096 | |
| natagaima | 344938 | 11.6% |
| guatica | 130373 | 4.4% |
| girardota | 76933 | 2.6% |
| de | 73795 | 2.5% |
| santa | 55005 | 1.8% |
| matias | 41568 | 1.4% |
| don | 41568 | 1.4% |
| la | 41561 | 1.4% |
| Other values (808) | 1032091 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 4411816 | |
| I | 2769839 | |
| U | 1603758 | 7.3% |
| T | 1514641 | 6.9% |
| L | 1511166 | 6.9% |
| N | 1433658 | 6.5% |
| R | 1293458 | 5.9% |
| V | 1237070 | 5.6% |
| E | 1222356 | 5.6% |
| C | 1085694 | 5.0% |
| Other values (25) | 3837817 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 21921273 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 4411816 | |
| I | 2769839 | |
| U | 1603758 | 7.3% |
| T | 1514641 | 6.9% |
| L | 1511166 | 6.9% |
| N | 1433658 | 6.5% |
| R | 1293458 | 5.9% |
| V | 1237070 | 5.6% |
| E | 1222356 | 5.6% |
| C | 1085694 | 5.0% |
| Other values (25) | 3837817 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 21921273 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 4411816 | |
| I | 2769839 | |
| U | 1603758 | 7.3% |
| T | 1514641 | 6.9% |
| L | 1511166 | 6.9% |
| N | 1433658 | 6.5% |
| R | 1293458 | 5.9% |
| V | 1237070 | 5.6% |
| E | 1222356 | 5.6% |
| C | 1085694 | 5.0% |
| Other values (25) | 3837817 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 21921273 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 4411816 | |
| I | 2769839 | |
| U | 1603758 | 7.3% |
| T | 1514641 | 6.9% |
| L | 1511166 | 6.9% |
| N | 1433658 | 6.5% |
| R | 1293458 | 5.9% |
| V | 1237070 | 5.6% |
| E | 1222356 | 5.6% |
| C | 1085694 | 5.0% |
| Other values (25) | 3837817 |
zona
Categorical
High correlation 
| Distinct | 34 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 143.0 MiB |
| SANTANDER | |
|---|---|
| LA GUAJIRA | |
| TOLIMA | |
| ANTIOQUIA | |
| RISARALDA | |
| Other values (29) |
Length
| Max length | 15 |
|---|---|
| Median length | 12 |
| Mean length | 8.6370447 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SANTANDER |
|---|---|
| 2nd row | LA GUAJIRA |
| 3rd row | LA GUAJIRA |
| 4th row | LA GUAJIRA |
| 5th row | LA GUAJIRA |
Common Values
| Value | Count | Frequency (%) |
| SANTANDER | 739403 | |
| LA GUAJIRA | 572599 | |
| TOLIMA | 407942 | |
| ANTIOQUIA | 226327 | 8.8% |
| RISARALDA | 132899 | 5.2% |
| CUNDINAMARCA | 107104 | 4.2% |
| NORTE SANTANDER | 59121 | 2.3% |
| BOYACA | 50586 | 2.0% |
| CAUCA | 39420 | 1.5% |
| HUILA | 36280 | 1.4% |
| Other values (24) | 197043 | 7.7% |
Length
| Value | Count | Frequency (%) |
| santander | 798524 | |
| la | 572599 | |
| guajira | 572599 | |
| tolima | 407942 | |
| antioquia | 226327 | 7.1% |
| risaralda | 132899 | 4.2% |
| cundinamarca | 107104 | 3.3% |
| norte | 59121 | 1.8% |
| boyaca | 50586 | 1.6% |
| cauca | 39420 | 1.2% |
| Other values (26) | 233557 | 7.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 5370583 | |
| N | 2186344 | |
| R | 1880810 | 8.5% |
| I | 1772480 | 8.0% |
| T | 1589719 | 7.2% |
| L | 1268729 | 5.7% |
| D | 1062422 | 4.8% |
| U | 994194 | 4.5% |
| S | 973844 | 4.4% |
| E | 959161 | 4.3% |
| Other values (20) | 4127898 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 22186184 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 5370583 | |
| N | 2186344 | |
| R | 1880810 | 8.5% |
| I | 1772480 | 8.0% |
| T | 1589719 | 7.2% |
| L | 1268729 | 5.7% |
| D | 1062422 | 4.8% |
| U | 994194 | 4.5% |
| S | 973844 | 4.4% |
| E | 959161 | 4.3% |
| Other values (20) | 4127898 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 22186184 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 5370583 | |
| N | 2186344 | |
| R | 1880810 | 8.5% |
| I | 1772480 | 8.0% |
| T | 1589719 | 7.2% |
| L | 1268729 | 5.7% |
| D | 1062422 | 4.8% |
| U | 994194 | 4.5% |
| S | 973844 | 4.4% |
| E | 959161 | 4.3% |
| Other values (20) | 4127898 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 22186184 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 5370583 | |
| N | 2186344 | |
| R | 1880810 | 8.5% |
| I | 1772480 | 8.0% |
| T | 1589719 | 7.2% |
| L | 1268729 | 5.7% |
| D | 1062422 | 4.8% |
| U | 994194 | 4.5% |
| S | 973844 | 4.4% |
| E | 959161 | 4.3% |
| Other values (20) | 4127898 |
asesor
Text
| Distinct | 608 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 143.5 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.5900871 |
| Min length | 8 |
Unique
| Unique | 18 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | asesor_2 |
|---|---|
| 2nd row | asesor_3 |
| 3rd row | asesor_3 |
| 4th row | asesor_3 |
| 5th row | asesor_3 |
| Value | Count | Frequency (%) |
| asesor_137 | 42270 | 1.6% |
| asesor_251 | 40478 | 1.6% |
| asesor_7 | 39721 | 1.5% |
| asesor_197 | 32477 | 1.3% |
| asesor_122 | 31884 | 1.2% |
| asesor_9 | 31405 | 1.2% |
| asesor_103 | 30051 | 1.2% |
| asesor_255 | 29499 | 1.1% |
| asesor_397 | 28404 | 1.1% |
| asesor_2 | 27953 | 1.1% |
| Other values (598) | 2234582 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 5137448 | |
| a | 2568724 | |
| e | 2568724 | |
| o | 2568724 | |
| r | 2568724 | |
| _ | 2568724 | |
| 1 | 1379679 | 5.6% |
| 2 | 1054242 | 4.3% |
| 3 | 789343 | 3.2% |
| 7 | 612227 | 2.5% |
| Other values (6) | 2817728 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 24634287 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 5137448 | |
| a | 2568724 | |
| e | 2568724 | |
| o | 2568724 | |
| r | 2568724 | |
| _ | 2568724 | |
| 1 | 1379679 | 5.6% |
| 2 | 1054242 | 4.3% |
| 3 | 789343 | 3.2% |
| 7 | 612227 | 2.5% |
| Other values (6) | 2817728 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 24634287 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 5137448 | |
| a | 2568724 | |
| e | 2568724 | |
| o | 2568724 | |
| r | 2568724 | |
| _ | 2568724 | |
| 1 | 1379679 | 5.6% |
| 2 | 1054242 | 4.3% |
| 3 | 789343 | 3.2% |
| 7 | 612227 | 2.5% |
| Other values (6) | 2817728 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 24634287 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 5137448 | |
| a | 2568724 | |
| e | 2568724 | |
| o | 2568724 | |
| r | 2568724 | |
| _ | 2568724 | |
| 1 | 1379679 | 5.6% |
| 2 | 1054242 | 4.3% |
| 3 | 789343 | 3.2% |
| 7 | 612227 | 2.5% |
| Other values (6) | 2817728 |
punto de venta
Text
| Distinct | 66 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 153.3 MiB |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 13.588146 |
| Min length | 13 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | punto_venta_2 |
|---|---|
| 2nd row | punto_venta_2 |
| 3rd row | punto_venta_2 |
| 4th row | punto_venta_2 |
| 5th row | punto_venta_2 |
| Value | Count | Frequency (%) |
| punto_venta_2 | 343666 | 13.4% |
| punto_venta_33 | 194569 | 7.6% |
| punto_venta_7 | 132891 | 5.2% |
| punto_venta_4 | 124219 | 4.8% |
| punto_venta_6 | 116909 | 4.6% |
| punto_venta_21 | 112599 | 4.4% |
| punto_venta_10 | 107327 | 4.2% |
| punto_venta_9 | 101799 | 4.0% |
| punto_venta_3 | 84689 | 3.3% |
| punto_venta_1 | 74783 | 2.9% |
| Other values (56) | 1175273 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 5137448 | |
| t | 5137448 | |
| _ | 5137448 | |
| p | 2568724 | |
| u | 2568724 | |
| o | 2568724 | |
| v | 2568724 | |
| e | 2568724 | |
| a | 2568724 | |
| 2 | 999527 | 2.9% |
| Other values (9) | 3079983 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 34904198 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 5137448 | |
| t | 5137448 | |
| _ | 5137448 | |
| p | 2568724 | |
| u | 2568724 | |
| o | 2568724 | |
| v | 2568724 | |
| e | 2568724 | |
| a | 2568724 | |
| 2 | 999527 | 2.9% |
| Other values (9) | 3079983 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 34904198 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 5137448 | |
| t | 5137448 | |
| _ | 5137448 | |
| p | 2568724 | |
| u | 2568724 | |
| o | 2568724 | |
| v | 2568724 | |
| e | 2568724 | |
| a | 2568724 | |
| 2 | 999527 | 2.9% |
| Other values (9) | 3079983 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 34904198 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 5137448 | |
| t | 5137448 | |
| _ | 5137448 | |
| p | 2568724 | |
| u | 2568724 | |
| o | 2568724 | |
| v | 2568724 | |
| e | 2568724 | |
| a | 2568724 | |
| 2 | 999527 | 2.9% |
| Other values (9) | 3079983 |
cluster
Categorical
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 159.2 MiB |
| cluster_tienda_3 | |
|---|---|
| cluster_tienda_2 | |
| cluster_tienda_1 | |
| cluster_tienda_4 | 98969 |
| cluster_tienda_5 | 26635 |
| Other values (4) | 2830 |
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 16 |
| Min length | 16 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | cluster_tienda_2 |
|---|---|
| 2nd row | cluster_tienda_2 |
| 3rd row | cluster_tienda_2 |
| 4th row | cluster_tienda_2 |
| 5th row | cluster_tienda_2 |
Common Values
| Value | Count | Frequency (%) |
| cluster_tienda_3 | 1158447 | |
| cluster_tienda_2 | 1071931 | |
| cluster_tienda_1 | 209912 | 8.2% |
| cluster_tienda_4 | 98969 | 3.9% |
| cluster_tienda_5 | 26635 | 1.0% |
| cluster_tienda_6 | 1246 | < 0.1% |
| cluster_tienda_8 | 830 | < 0.1% |
| cluster_tienda_7 | 753 | < 0.1% |
| cluster_tienda_9 | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| cluster_tienda_3 | 1158447 | |
| cluster_tienda_2 | 1071931 | |
| cluster_tienda_1 | 209912 | 8.2% |
| cluster_tienda_4 | 98969 | 3.9% |
| cluster_tienda_5 | 26635 | 1.0% |
| cluster_tienda_6 | 1246 | < 0.1% |
| cluster_tienda_8 | 830 | < 0.1% |
| cluster_tienda_7 | 753 | < 0.1% |
| cluster_tienda_9 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 5137448 | |
| e | 5137448 | |
| _ | 5137448 | |
| c | 2568724 | 6.2% |
| i | 2568724 | 6.2% |
| a | 2568724 | 6.2% |
| l | 2568724 | 6.2% |
| n | 2568724 | 6.2% |
| d | 2568724 | 6.2% |
| r | 2568724 | 6.2% |
| Other values (11) | 7706172 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 41099584 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 5137448 | |
| e | 5137448 | |
| _ | 5137448 | |
| c | 2568724 | 6.2% |
| i | 2568724 | 6.2% |
| a | 2568724 | 6.2% |
| l | 2568724 | 6.2% |
| n | 2568724 | 6.2% |
| d | 2568724 | 6.2% |
| r | 2568724 | 6.2% |
| Other values (11) | 7706172 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 41099584 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 5137448 | |
| e | 5137448 | |
| _ | 5137448 | |
| c | 2568724 | 6.2% |
| i | 2568724 | 6.2% |
| a | 2568724 | 6.2% |
| l | 2568724 | 6.2% |
| n | 2568724 | 6.2% |
| d | 2568724 | 6.2% |
| r | 2568724 | 6.2% |
| Other values (11) | 7706172 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 41099584 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 5137448 | |
| e | 5137448 | |
| _ | 5137448 | |
| c | 2568724 | 6.2% |
| i | 2568724 | 6.2% |
| a | 2568724 | 6.2% |
| l | 2568724 | 6.2% |
| n | 2568724 | 6.2% |
| d | 2568724 | 6.2% |
| r | 2568724 | 6.2% |
| Other values (11) | 7706172 |
categoria_macro
Categorical
High correlation 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 161.7 MiB |
| categoria_macro_2 | |
|---|---|
| categoria_macro_4 | |
| categoria_macro_1 | |
| categoria_macro_3 | 112996 |
| categoria_macro_5 | 11655 |
Length
| Max length | 17 |
|---|---|
| Median length | 17 |
| Mean length | 17 |
| Min length | 17 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | categoria_macro_1 |
|---|---|
| 2nd row | categoria_macro_2 |
| 3rd row | categoria_macro_2 |
| 4th row | categoria_macro_2 |
| 5th row | categoria_macro_2 |
Common Values
| Value | Count | Frequency (%) |
| categoria_macro_2 | 1602004 | |
| categoria_macro_4 | 620206 | 24.1% |
| categoria_macro_1 | 221863 | 8.6% |
| categoria_macro_3 | 112996 | 4.4% |
| categoria_macro_5 | 11655 | 0.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| categoria_macro_2 | 1602004 | |
| categoria_macro_4 | 620206 | 24.1% |
| categoria_macro_1 | 221863 | 8.6% |
| categoria_macro_3 | 112996 | 4.4% |
| categoria_macro_5 | 11655 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 7706172 | |
| c | 5137448 | |
| o | 5137448 | |
| r | 5137448 | |
| _ | 5137448 | |
| t | 2568724 | 5.9% |
| e | 2568724 | 5.9% |
| g | 2568724 | 5.9% |
| i | 2568724 | 5.9% |
| m | 2568724 | 5.9% |
| Other values (5) | 2568724 | 5.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 43668308 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 7706172 | |
| c | 5137448 | |
| o | 5137448 | |
| r | 5137448 | |
| _ | 5137448 | |
| t | 2568724 | 5.9% |
| e | 2568724 | 5.9% |
| g | 2568724 | 5.9% |
| i | 2568724 | 5.9% |
| m | 2568724 | 5.9% |
| Other values (5) | 2568724 | 5.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 43668308 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 7706172 | |
| c | 5137448 | |
| o | 5137448 | |
| r | 5137448 | |
| _ | 5137448 | |
| t | 2568724 | 5.9% |
| e | 2568724 | 5.9% |
| g | 2568724 | 5.9% |
| i | 2568724 | 5.9% |
| m | 2568724 | 5.9% |
| Other values (5) | 2568724 | 5.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 43668308 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 7706172 | |
| c | 5137448 | |
| o | 5137448 | |
| r | 5137448 | |
| _ | 5137448 | |
| t | 2568724 | 5.9% |
| e | 2568724 | 5.9% |
| g | 2568724 | 5.9% |
| i | 2568724 | 5.9% |
| m | 2568724 | 5.9% |
| Other values (5) | 2568724 | 5.9% |
categoria
Categorical
High correlation 
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 147.5 MiB |
| categoria_3 | |
|---|---|
| categoria_7 | |
| categoria_5 | |
| categoria_11 | |
| categoria_1 | |
| Other values (22) |
Length
| Max length | 12 |
|---|---|
| Median length | 11 |
| Mean length | 11.213218 |
| Min length | 11 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | categoria_2 |
|---|---|
| 2nd row | categoria_3 |
| 3rd row | categoria_3 |
| 4th row | categoria_3 |
| 5th row | categoria_3 |
Common Values
| Value | Count | Frequency (%) |
| categoria_3 | 566967 | |
| categoria_7 | 535182 | |
| categoria_5 | 359200 | |
| categoria_11 | 195663 | 7.6% |
| categoria_1 | 176468 | 6.9% |
| categoria_12 | 162338 | 6.3% |
| categoria_8 | 138936 | 5.4% |
| categoria_9 | 100276 | 3.9% |
| categoria_10 | 65163 | 2.5% |
| categoria_6 | 59967 | 2.3% |
| Other values (17) | 208564 | 8.1% |
Length
| Value | Count | Frequency (%) |
| categoria_3 | 566967 | |
| categoria_7 | 535182 | |
| categoria_5 | 359200 | |
| categoria_11 | 195663 | 7.6% |
| categoria_1 | 176468 | 6.9% |
| categoria_12 | 162338 | 6.3% |
| categoria_8 | 138936 | 5.4% |
| categoria_9 | 100276 | 3.9% |
| categoria_10 | 65163 | 2.5% |
| categoria_6 | 59967 | 2.3% |
| Other values (17) | 208564 | 8.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 5137448 | |
| c | 2568724 | |
| t | 2568724 | |
| e | 2568724 | |
| g | 2568724 | |
| o | 2568724 | |
| r | 2568724 | |
| i | 2568724 | |
| _ | 2568724 | |
| 1 | 895544 | 3.1% |
| Other values (9) | 2220877 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 28803661 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 5137448 | |
| c | 2568724 | |
| t | 2568724 | |
| e | 2568724 | |
| g | 2568724 | |
| o | 2568724 | |
| r | 2568724 | |
| i | 2568724 | |
| _ | 2568724 | |
| 1 | 895544 | 3.1% |
| Other values (9) | 2220877 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 28803661 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 5137448 | |
| c | 2568724 | |
| t | 2568724 | |
| e | 2568724 | |
| g | 2568724 | |
| o | 2568724 | |
| r | 2568724 | |
| i | 2568724 | |
| _ | 2568724 | |
| 1 | 895544 | 3.1% |
| Other values (9) | 2220877 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 28803661 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 5137448 | |
| c | 2568724 | |
| t | 2568724 | |
| e | 2568724 | |
| g | 2568724 | |
| o | 2568724 | |
| r | 2568724 | |
| i | 2568724 | |
| _ | 2568724 | |
| 1 | 895544 | 3.1% |
| Other values (9) | 2220877 |
subcategoria
Text
| Distinct | 102 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 155.4 MiB |
Length
| Max length | 16 |
|---|---|
| Median length | 14 |
| Mean length | 14.426673 |
| Min length | 14 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | subcategoria_2 |
|---|---|
| 2nd row | subcategoria_3 |
| 3rd row | subcategoria_3 |
| 4th row | subcategoria_3 |
| 5th row | subcategoria_3 |
| Value | Count | Frequency (%) |
| subcategoria_5 | 822252 | |
| subcategoria_3 | 296439 | 11.5% |
| subcategoria_9 | 194553 | 7.6% |
| subcategoria_12 | 94339 | 3.7% |
| subcategoria_14 | 87146 | 3.4% |
| subcategoria_22 | 75970 | 3.0% |
| subcategoria_7 | 72048 | 2.8% |
| subcategoria_13 | 62574 | 2.4% |
| subcategoria_39 | 61477 | 2.4% |
| subcategoria_24 | 58349 | 2.3% |
| Other values (92) | 743577 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 5137448 | |
| s | 2568724 | 6.9% |
| g | 2568724 | 6.9% |
| u | 2568724 | 6.9% |
| i | 2568724 | 6.9% |
| r | 2568724 | 6.9% |
| o | 2568724 | 6.9% |
| _ | 2568724 | 6.9% |
| e | 2568724 | 6.9% |
| t | 2568724 | 6.9% |
| Other values (12) | 8802178 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 37058142 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 5137448 | |
| s | 2568724 | 6.9% |
| g | 2568724 | 6.9% |
| u | 2568724 | 6.9% |
| i | 2568724 | 6.9% |
| r | 2568724 | 6.9% |
| o | 2568724 | 6.9% |
| _ | 2568724 | 6.9% |
| e | 2568724 | 6.9% |
| t | 2568724 | 6.9% |
| Other values (12) | 8802178 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 37058142 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 5137448 | |
| s | 2568724 | 6.9% |
| g | 2568724 | 6.9% |
| u | 2568724 | 6.9% |
| i | 2568724 | 6.9% |
| r | 2568724 | 6.9% |
| o | 2568724 | 6.9% |
| _ | 2568724 | 6.9% |
| e | 2568724 | 6.9% |
| t | 2568724 | 6.9% |
| Other values (12) | 8802178 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 37058142 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 5137448 | |
| s | 2568724 | 6.9% |
| g | 2568724 | 6.9% |
| u | 2568724 | 6.9% |
| i | 2568724 | 6.9% |
| r | 2568724 | 6.9% |
| o | 2568724 | 6.9% |
| _ | 2568724 | 6.9% |
| e | 2568724 | 6.9% |
| t | 2568724 | 6.9% |
| Other values (12) | 8802178 |
producto
Text
| Distinct | 7263 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.3 MiB |
Length
| Max length | 13 |
|---|---|
| Median length | 12 |
| Mean length | 11.963088 |
| Min length | 10 |
Unique
| Unique | 958 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | producto_2 |
|---|---|
| 2nd row | producto_3 |
| 3rd row | producto_3 |
| 4th row | producto_3 |
| 5th row | producto_3 |
| Value | Count | Frequency (%) |
| producto_19 | 69248 | 2.7% |
| producto_49 | 61396 | 2.4% |
| producto_40 | 32927 | 1.3% |
| producto_28 | 32313 | 1.3% |
| producto_176 | 31598 | 1.2% |
| producto_3 | 30504 | 1.2% |
| producto_110 | 30023 | 1.2% |
| producto_72 | 27744 | 1.1% |
| producto_119 | 26915 | 1.0% |
| producto_112 | 25300 | 1.0% |
| Other values (7253) | 2200756 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 5137448 | |
| p | 2568724 | |
| d | 2568724 | |
| u | 2568724 | |
| c | 2568724 | |
| t | 2568724 | |
| _ | 2568724 | |
| r | 2568724 | |
| 1 | 1374583 | 4.5% |
| 2 | 911738 | 3.0% |
| Other values (8) | 5325033 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 30729870 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 5137448 | |
| p | 2568724 | |
| d | 2568724 | |
| u | 2568724 | |
| c | 2568724 | |
| t | 2568724 | |
| _ | 2568724 | |
| r | 2568724 | |
| 1 | 1374583 | 4.5% |
| 2 | 911738 | 3.0% |
| Other values (8) | 5325033 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 30729870 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 5137448 | |
| p | 2568724 | |
| d | 2568724 | |
| u | 2568724 | |
| c | 2568724 | |
| t | 2568724 | |
| _ | 2568724 | |
| r | 2568724 | |
| 1 | 1374583 | 4.5% |
| 2 | 911738 | 3.0% |
| Other values (8) | 5325033 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 30729870 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 5137448 | |
| p | 2568724 | |
| d | 2568724 | |
| u | 2568724 | |
| c | 2568724 | |
| t | 2568724 | |
| _ | 2568724 | |
| r | 2568724 | |
| 1 | 1374583 | 4.5% |
| 2 | 911738 | 3.0% |
| Other values (8) | 5325033 |
color
Text
| Distinct | 68 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 141.8 MiB |
Length
| Max length | 13 |
|---|---|
| Median length | 12 |
| Mean length | 8.8936266 |
| Min length | 3 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | GRIS |
|---|---|
| 2nd row | BEIGE |
| 3rd row | BEIGE |
| 4th row | BEIGE |
| 5th row | BEIGE |
| Value | Count | Frequency (%) |
| no | 1196257 | |
| encontrado | 1196257 | |
| gris | 515685 | |
| blanco | 303687 | 8.1% |
| beige | 220542 | 5.9% |
| multicolor | 106369 | 2.8% |
| marfil | 54243 | 1.4% |
| negro | 48494 | 1.3% |
| azul | 35037 | 0.9% |
| mate | 18145 | 0.5% |
| Other values (59) | 70265 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 3588771 | |
| n | 2392514 | 10.5% |
| N | 1575543 | 6.9% |
| 1196257 | 5.2% | |
| e | 1196257 | 5.2% |
| c | 1196257 | 5.2% |
| t | 1196257 | 5.2% |
| r | 1196257 | 5.2% |
| a | 1196257 | 5.2% |
| d | 1196257 | 5.2% |
| Other values (26) | 6914645 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 22845272 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 3588771 | |
| n | 2392514 | 10.5% |
| N | 1575543 | 6.9% |
| 1196257 | 5.2% | |
| e | 1196257 | 5.2% |
| c | 1196257 | 5.2% |
| t | 1196257 | 5.2% |
| r | 1196257 | 5.2% |
| a | 1196257 | 5.2% |
| d | 1196257 | 5.2% |
| Other values (26) | 6914645 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 22845272 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 3588771 | |
| n | 2392514 | 10.5% |
| N | 1575543 | 6.9% |
| 1196257 | 5.2% | |
| e | 1196257 | 5.2% |
| c | 1196257 | 5.2% |
| t | 1196257 | 5.2% |
| r | 1196257 | 5.2% |
| a | 1196257 | 5.2% |
| d | 1196257 | 5.2% |
| Other values (26) | 6914645 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 22845272 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 3588771 | |
| n | 2392514 | 10.5% |
| N | 1575543 | 6.9% |
| 1196257 | 5.2% | |
| e | 1196257 | 5.2% |
| c | 1196257 | 5.2% |
| t | 1196257 | 5.2% |
| r | 1196257 | 5.2% |
| a | 1196257 | 5.2% |
| d | 1196257 | 5.2% |
| Other values (26) | 6914645 |
cantidad
Real number (ℝ)
High correlation  Skewed 
| Distinct | 6229 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.601075 |
| Minimum | 0.15 |
|---|---|
| Maximum | 489689 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 0.15 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 3 |
| Q3 | 12.8 |
| 95-th percentile | 140.14 |
| Maximum | 489689 |
| Range | 489688.85 |
| Interquartile range (IQR) | 11.8 |
Descriptive statistics
| Standard deviation | 680.68267 |
|---|---|
| Coefficient of variation (CV) | 18.597341 |
| Kurtosis | 238348.65 |
| Mean | 36.601075 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 407.67185 |
| Sum | 94018061 |
| Variance | 463328.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 725909 | |
| 2 | 327616 | 12.8% |
| 5 | 91126 | 3.5% |
| 25 | 59469 | 2.3% |
| 4 | 57452 | 2.2% |
| 3 | 49614 | 1.9% |
| 10 | 42112 | 1.6% |
| 50 | 39743 | 1.5% |
| 6 | 26796 | 1.0% |
| 3.2 | 26434 | 1.0% |
| Other values (6219) | 1122453 |
| Value | Count | Frequency (%) |
| 0.15 | 1 | < 0.1% |
| 0.33 | 1 | < 0.1% |
| 0.4 | 33 | < 0.1% |
| 0.42 | 1 | < 0.1% |
| 0.48 | 91 | |
| 0.5 | 13 | < 0.1% |
| 0.52 | 16 | < 0.1% |
| 0.54 | 38 | |
| 0.57 | 1 | < 0.1% |
| 0.61 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 489689 | 1 | |
| 477673 | 1 | |
| 264542 | 1 | |
| 262179 | 1 | |
| 251039 | 1 | |
| 246562 | 1 | |
| 189346 | 1 | |
| 167730 | 1 | |
| 162539 | 1 | |
| 130591 | 1 |
precio
Real number (ℝ)
High correlation  Skewed 
| Distinct | 9635 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.0983616 |
| Minimum | 0 |
|---|---|
| Maximum | 12043.48 |
| Zeros | 67 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.12 |
| Q1 | 0.65 |
| median | 3.01 |
| Q3 | 6.16 |
| 95-th percentile | 43 |
| Maximum | 12043.48 |
| Range | 12043.48 |
| Interquartile range (IQR) | 5.51 |
Descriptive statistics
| Standard deviation | 28.918855 |
|---|---|
| Coefficient of variation (CV) | 3.1784684 |
| Kurtosis | 18258.202 |
| Mean | 9.0983616 |
| Median Absolute Deviation (MAD) | 2.41 |
| Skewness | 75.645332 |
| Sum | 23371180 |
| Variance | 836.30017 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.56 | 54220 | 2.1% |
| 0.6 | 47463 | 1.8% |
| 0.5 | 45569 | 1.8% |
| 0.47 | 40941 | 1.6% |
| 0.07 | 36285 | 1.4% |
| 0.65 | 35864 | 1.4% |
| 0.15 | 31009 | 1.2% |
| 0.11 | 27962 | 1.1% |
| 0.13 | 26860 | 1.0% |
| 0.58 | 24410 | 1.0% |
| Other values (9625) | 2198141 |
| Value | Count | Frequency (%) |
| 0 | 67 | < 0.1% |
| 0.01 | 2 | < 0.1% |
| 0.04 | 373 | < 0.1% |
| 0.05 | 60 | < 0.1% |
| 0.06 | 2832 | 0.1% |
| 0.07 | 36285 | |
| 0.08 | 23595 | |
| 0.09 | 23979 | |
| 0.1 | 3888 | 0.2% |
| 0.11 | 27962 |
| Value | Count | Frequency (%) |
| 12043.48 | 1 | < 0.1% |
| 6451.52 | 1 | < 0.1% |
| 5833.75 | 1 | < 0.1% |
| 5592.58 | 1 | < 0.1% |
| 5591.54 | 4 | |
| 4955.1 | 1 | < 0.1% |
| 4816.04 | 1 | < 0.1% |
| 4099.78 | 1 | < 0.1% |
| 4044.55 | 1 | < 0.1% |
| 3846.93 | 2 |
valor
Real number (ℝ)
High correlation  Skewed 
| Distinct | 46578 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.472455 |
| Minimum | 0.07 |
|---|---|
| Maximum | 56876.09 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 0.07 |
|---|---|
| 5-th percentile | 1.14 |
| Q1 | 4.69 |
| median | 12.9 |
| Q3 | 36.2 |
| 95-th percentile | 142.1785 |
| Maximum | 56876.09 |
| Range | 56876.02 |
| Interquartile range (IQR) | 31.51 |
Descriptive statistics
| Standard deviation | 153.75788 |
|---|---|
| Coefficient of variation (CV) | 3.9965705 |
| Kurtosis | 20340.008 |
| Mean | 38.472455 |
| Median Absolute Deviation (MAD) | 10.48 |
| Skewness | 88.626893 |
| Sum | 98825118 |
| Variance | 23641.485 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.13 | 42912 | 1.7% |
| 1.2 | 40207 | 1.6% |
| 2.34 | 25645 | 1.0% |
| 1.3 | 22891 | 0.9% |
| 2.49 | 20050 | 0.8% |
| 0.35 | 16851 | 0.7% |
| 1.17 | 16328 | 0.6% |
| 2.67 | 11964 | 0.5% |
| 2.5 | 11937 | 0.5% |
| 4.69 | 9564 | 0.4% |
| Other values (46568) | 2350375 |
| Value | Count | Frequency (%) |
| 0.07 | 32 | < 0.1% |
| 0.08 | 2 | < 0.1% |
| 0.09 | 22 | < 0.1% |
| 0.1 | 39 | < 0.1% |
| 0.11 | 19 | < 0.1% |
| 0.12 | 40 | < 0.1% |
| 0.13 | 235 | |
| 0.14 | 32 | < 0.1% |
| 0.15 | 86 | < 0.1% |
| 0.16 | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 56876.09 | 1 | |
| 55491.7 | 1 | |
| 32647.37 | 1 | |
| 32398.94 | 1 | |
| 30571.52 | 1 | |
| 30508.79 | 1 | |
| 30434.9 | 1 | |
| 29158.44 | 1 | |
| 28599.27 | 1 | |
| 24053.41 | 1 |
alineación con portafolio estratégico
Real number (ℝ)
High correlation  Skewed 
| Distinct | 24003 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.8254732 |
| Minimum | -24187.463 |
|---|---|
| Maximum | 4162.2266 |
| Zeros | 1672 |
| Zeros (%) | 0.1% |
| Negative | 1520 |
| Negative (%) | 0.1% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | -24187.463 |
|---|---|
| 5-th percentile | 0.117504 |
| Q1 | 0.46656 |
| median | 1.3824 |
| Q3 | 3.652992 |
| 95-th percentile | 13.78944 |
| Maximum | 4162.2266 |
| Range | 28349.69 |
| Interquartile range (IQR) | 3.186432 |
Descriptive statistics
| Standard deviation | 20.320648 |
|---|---|
| Coefficient of variation (CV) | 5.3119306 |
| Kurtosis | 784122.68 |
| Mean | 3.8254732 |
| Median Absolute Deviation (MAD) | 1.1232 |
| Skewness | -638.33381 |
| Sum | 9826584.8 |
| Variance | 412.92873 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.124416 | 45432 | 1.8% |
| 0.117504 | 42682 | 1.7% |
| 0.2592 | 31017 | 1.2% |
| 0.134784 | 26327 | 1.0% |
| 0.048384 | 23665 | 0.9% |
| 0.245376 | 23210 | 0.9% |
| 0.12096 | 15691 | 0.6% |
| 0.487296 | 13989 | 0.5% |
| 0.27648 | 13468 | 0.5% |
| 0.5184 | 10708 | 0.4% |
| Other values (23993) | 2322535 |
| Value | Count | Frequency (%) |
| -24187.463 | 1 | < 0.1% |
| -1712.1749 | 1 | < 0.1% |
| -796.1898 | 1 | < 0.1% |
| -701.06 | 1 | < 0.1% |
| -684.16016 | 1 | < 0.1% |
| -497.7262 | 1 | < 0.1% |
| -455.72888 | 1 | < 0.1% |
| -215.04614 | 1 | < 0.1% |
| -193.44269 | 1 | < 0.1% |
| -78.08832 | 4 |
| Value | Count | Frequency (%) |
| 4162.2266 | 1 | < 0.1% |
| 3887.008 | 1 | < 0.1% |
| 2969.6543 | 1 | < 0.1% |
| 2900.6692 | 1 | < 0.1% |
| 2229.6453 | 1 | < 0.1% |
| 2158.8525 | 1 | < 0.1% |
| 2016.144 | 1 | < 0.1% |
| 1932.7957 | 1 | < 0.1% |
| 1932.4363 | 4 | |
| 1788.9984 | 1 | < 0.1% |
log_cantidad
Real number (ℝ)
High correlation 
| Distinct | 6229 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.9180917 |
| Minimum | 0.13976195 |
|---|---|
| Maximum | 13.101528 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 0.13976195 |
|---|---|
| 5-th percentile | 0.6931472 |
| Q1 | 0.6931472 |
| median | 1.3862944 |
| Q3 | 2.6246686 |
| 95-th percentile | 4.9497523 |
| Maximum | 13.101528 |
| Range | 12.961766 |
| Interquartile range (IQR) | 1.9315214 |
Descriptive statistics
| Standard deviation | 1.4139768 |
|---|---|
| Coefficient of variation (CV) | 0.73717895 |
| Kurtosis | 1.4442283 |
| Mean | 1.9180917 |
| Median Absolute Deviation (MAD) | 0.6931472 |
| Skewness | 1.3756699 |
| Sum | 4927048.2 |
| Variance | 1.9993304 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.6931472 | 725909 | |
| 1.0986123 | 327616 | 12.8% |
| 1.7917595 | 91126 | 3.5% |
| 3.2580965 | 59469 | 2.3% |
| 1.609438 | 57452 | 2.2% |
| 1.3862944 | 49614 | 1.9% |
| 2.3978953 | 42112 | 1.6% |
| 3.9318256 | 39743 | 1.5% |
| 1.9459101 | 26796 | 1.0% |
| 1.4350845 | 26434 | 1.0% |
| Other values (6219) | 1122453 |
| Value | Count | Frequency (%) |
| 0.13976195 | 1 | < 0.1% |
| 0.28517896 | 1 | < 0.1% |
| 0.33647224 | 33 | < 0.1% |
| 0.35065687 | 1 | < 0.1% |
| 0.39204207 | 91 | |
| 0.4054651 | 13 | < 0.1% |
| 0.41871032 | 16 | < 0.1% |
| 0.43178242 | 38 | |
| 0.4510756 | 1 | < 0.1% |
| 0.4762342 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 13.101528 | 1 | |
| 13.076684 | 1 | |
| 12.485759 | 1 | |
| 12.476787 | 1 | |
| 12.433368 | 1 | |
| 12.415373 | 1 | |
| 12.151337 | 1 | |
| 12.030117 | 1 | |
| 11.998679 | 1 | |
| 11.779833 | 1 |
log_precio
Real number (ℝ)
High correlation 
| Distinct | 9635 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.5204145 |
| Minimum | 0 |
|---|---|
| Maximum | 9.396361 |
| Zeros | 67 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.11332868 |
| Q1 | 0.5007753 |
| median | 1.3887913 |
| Q3 | 1.9685099 |
| 95-th percentile | 3.7841897 |
| Maximum | 9.396361 |
| Range | 9.396361 |
| Interquartile range (IQR) | 1.4677346 |
Descriptive statistics
| Standard deviation | 1.0945442 |
|---|---|
| Coefficient of variation (CV) | 0.71989856 |
| Kurtosis | 0.48589673 |
| Mean | 1.5204145 |
| Median Absolute Deviation (MAD) | 0.6981223 |
| Skewness | 0.90810704 |
| Sum | 3905525.3 |
| Variance | 1.198027 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.44468582 | 54220 | 2.1% |
| 0.47000363 | 47463 | 1.8% |
| 0.4054651 | 45569 | 1.8% |
| 0.3852624 | 40941 | 1.6% |
| 0.06765865 | 36285 | 1.4% |
| 0.5007753 | 35864 | 1.4% |
| 0.13976195 | 31009 | 1.2% |
| 0.104360014 | 27962 | 1.1% |
| 0.122217625 | 26860 | 1.0% |
| 0.45742482 | 24410 | 1.0% |
| Other values (9625) | 2198141 |
| Value | Count | Frequency (%) |
| 0 | 67 | < 0.1% |
| 0.0099503305 | 2 | < 0.1% |
| 0.039220713 | 373 | < 0.1% |
| 0.048790164 | 60 | < 0.1% |
| 0.058268905 | 2832 | 0.1% |
| 0.06765865 | 36285 | |
| 0.07696103 | 23595 | |
| 0.0861777 | 23979 | |
| 0.09531018 | 3888 | 0.2% |
| 0.104360014 | 27962 |
| Value | Count | Frequency (%) |
| 9.396361 | 1 | < 0.1% |
| 8.772226 | 1 | < 0.1% |
| 8.671587 | 1 | < 0.1% |
| 8.6293745 | 1 | < 0.1% |
| 8.629189 | 4 | |
| 8.508374 | 1 | < 0.1% |
| 8.479915 | 1 | < 0.1% |
| 8.318933 | 1 | < 0.1% |
| 8.305373 | 1 | < 0.1% |
| 8.255291 | 2 |
log_valor
Real number (ℝ)
High correlation 
| Distinct | 46578 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.7006973 |
| Minimum | 0.06765865 |
|---|---|
| Maximum | 10.948647 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 0.06765865 |
|---|---|
| 5-th percentile | 0.76080585 |
| Q1 | 1.7387103 |
| median | 2.6318889 |
| Q3 | 3.6163087 |
| 95-th percentile | 4.9640922 |
| Maximum | 10.948647 |
| Range | 10.880989 |
| Interquartile range (IQR) | 1.8775984 |
Descriptive statistics
| Standard deviation | 1.3098293 |
|---|---|
| Coefficient of variation (CV) | 0.48499673 |
| Kurtosis | -0.25988857 |
| Mean | 2.7006973 |
| Median Absolute Deviation (MAD) | 0.9362734 |
| Skewness | 0.35403333 |
| Sum | 6937345.9 |
| Variance | 1.7156529 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.756122 | 42912 | 1.7% |
| 0.7884574 | 40207 | 1.6% |
| 1.2059708 | 25645 | 1.0% |
| 0.8329091 | 22891 | 0.9% |
| 1.2499018 | 20050 | 0.8% |
| 0.3001046 | 16851 | 0.7% |
| 0.77472717 | 16328 | 0.6% |
| 1.3001916 | 11964 | 0.5% |
| 1.2527629 | 11937 | 0.5% |
| 1.7387103 | 9564 | 0.4% |
| Other values (46568) | 2350375 |
| Value | Count | Frequency (%) |
| 0.06765865 | 32 | < 0.1% |
| 0.07696103 | 2 | < 0.1% |
| 0.0861777 | 22 | < 0.1% |
| 0.09531018 | 39 | < 0.1% |
| 0.104360014 | 19 | < 0.1% |
| 0.11332868 | 40 | < 0.1% |
| 0.122217625 | 235 | |
| 0.13102826 | 32 | < 0.1% |
| 0.13976195 | 86 | < 0.1% |
| 0.14842 | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 10.9486475 | 1 | |
| 10.924006 | 1 | |
| 10.39355 | 1 | |
| 10.385912 | 1 | |
| 10.327857 | 1 | |
| 10.325803 | 1 | |
| 10.323379 | 1 | |
| 10.280534 | 1 | |
| 10.261171 | 1 | |
| 10.088074 | 1 |
ajustada_alineacion
Real number (ℝ)
High correlation  Skewed 
| Distinct | 24003 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.0067968525 |
| Minimum | -771.33545 |
|---|---|
| Maximum | 276.4262 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1997360 |
| Negative (%) | 77.8% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | -771.33545 |
|---|---|
| 5-th percentile | -0.2011434 |
| Q1 | -0.184258 |
| median | -0.13917093 |
| Q3 | -0.024373926 |
| 95-th percentile | 0.5112163 |
| Maximum | 276.4262 |
| Range | 1047.7616 |
| Interquartile range (IQR) | 0.15988407 |
Descriptive statistics
| Standard deviation | 0.94209111 |
|---|---|
| Coefficient of variation (CV) | -138.60697 |
| Kurtosis | 183559.67 |
| Mean | -0.0067968525 |
| Median Absolute Deviation (MAD) | 0.05514289 |
| Skewness | -164.04417 |
| Sum | -17459.238 |
| Variance | 0.88753565 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -0.2008111 | 45432 | 1.8% |
| -0.2011434 | 42682 | 1.7% |
| -0.19431382 | 31017 | 1.2% |
| -0.20031251 | 26327 | 1.0% |
| -0.20446117 | 23665 | 0.9% |
| -0.1949817 | 23210 | 0.9% |
| -0.20097728 | 15691 | 0.6% |
| -0.18324877 | 13989 | 0.5% |
| -0.1934785 | 13468 | 0.5% |
| -0.18173373 | 10708 | 0.4% |
| Other values (23993) | 2322535 |
| Value | Count | Frequency (%) |
| -771.33545 | 1 | < 0.1% |
| -61.64089 | 1 | < 0.1% |
| -29.762724 | 1 | < 0.1% |
| -26.37837 | 1 | < 0.1% |
| -25.775064 | 1 | < 0.1% |
| -19.070955 | 1 | < 0.1% |
| -17.54647 | 1 | < 0.1% |
| -8.662593 | 1 | < 0.1% |
| -7.8481994 | 1 | < 0.1% |
| -3.4135826 | 4 |
| Value | Count | Frequency (%) |
| 276.4262 | 1 | < 0.1% |
| 257.34677 | 1 | < 0.1% |
| 194.21335 | 1 | < 0.1% |
| 189.49796 | 1 | < 0.1% |
| 143.91191 | 1 | < 0.1% |
| 139.13548 | 1 | < 0.1% |
| 129.52835 | 1 | < 0.1% |
| 123.93126 | 1 | < 0.1% |
| 123.90715 | 4 | |
| 114.30045 | 1 | < 0.1% |
edad_promedio
Real number (ℝ)
High correlation 
| Distinct | 32 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4954 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35.674954 |
| Minimum | 28.311825 |
|---|---|
| Maximum | 41.152468 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 28.311825 |
|---|---|
| 5-th percentile | 29.862683 |
| Q1 | 34.193915 |
| median | 37.077072 |
| Q3 | 38.001476 |
| 95-th percentile | 39.272306 |
| Maximum | 41.152468 |
| Range | 12.840643 |
| Interquartile range (IQR) | 3.8075606 |
Descriptive statistics
| Standard deviation | 3.3572433 |
|---|---|
| Coefficient of variation (CV) | 0.094106449 |
| Kurtosis | -0.72522187 |
| Mean | 35.674954 |
| Median Absolute Deviation (MAD) | 1.5686651 |
| Skewness | -0.93713351 |
| Sum | 91462377 |
| Variance | 11.271082 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 37.07707192 | 739403 | |
| 29.86268292 | 572599 | |
| 38.64573702 | 407942 | |
| 38.00147566 | 226327 | 8.8% |
| 39.27230572 | 132899 | 5.2% |
| 36.7491788 | 107104 | 4.2% |
| 34.96857356 | 59121 | 2.3% |
| 36.26800506 | 50586 | 2.0% |
| 36.84756013 | 39420 | 1.5% |
| 35.76903746 | 36280 | 1.4% |
| Other values (22) | 192089 | 7.5% |
| Value | Count | Frequency (%) |
| 28.31182473 | 27 | < 0.1% |
| 28.83482587 | 180 | < 0.1% |
| 29.86268292 | 572599 | |
| 31.20435967 | 26107 | 1.0% |
| 31.66406992 | 16 | < 0.1% |
| 31.7555456 | 430 | < 0.1% |
| 32.10022272 | 793 | < 0.1% |
| 32.22589259 | 4018 | 0.2% |
| 32.31182538 | 177 | < 0.1% |
| 33.17039184 | 1034 | < 0.1% |
| Value | Count | Frequency (%) |
| 41.15246802 | 8184 | 0.3% |
| 40.63623799 | 5574 | 0.2% |
| 39.27230572 | 132899 | 5.2% |
| 38.64573702 | 407942 | |
| 38.00147566 | 226327 | 8.8% |
| 37.71364425 | 20181 | 0.8% |
| 37.68387216 | 27727 | 1.1% |
| 37.46664198 | 159 | < 0.1% |
| 37.28770028 | 234 | < 0.1% |
| 37.07707192 | 739403 |
ingreso_laboral_promedio
Real number (ℝ)
High correlation 
| Distinct | 32 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4954 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1616382.6 |
| Minimum | 1171393.5 |
|---|---|
| Maximum | 2593276 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 1171393.5 |
|---|---|
| 5-th percentile | 1212095.3 |
| Q1 | 1404703.6 |
| median | 1577079.1 |
| Q3 | 1801097.3 |
| 95-th percentile | 2107814 |
| Maximum | 2593276 |
| Range | 1421882.5 |
| Interquartile range (IQR) | 396393.75 |
Descriptive statistics
| Standard deviation | 278703.85 |
|---|---|
| Coefficient of variation (CV) | 0.17242443 |
| Kurtosis | -0.98872664 |
| Mean | 1616382.6 |
| Median Absolute Deviation (MAD) | 224018.21 |
| Skewness | -0.082277501 |
| Sum | 4.1440333 × 1012 |
| Variance | 7.7675838 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1801097.339 | 739403 | |
| 1212095.342 | 572599 | |
| 1550360.891 | 407942 | |
| 2107813.959 | 226327 | 8.8% |
| 1821178.566 | 132899 | 5.2% |
| 1507068.661 | 107104 | 4.2% |
| 1404703.587 | 59121 | 2.3% |
| 1839749.174 | 50586 | 2.0% |
| 1417425.912 | 39420 | 1.5% |
| 1577079.13 | 36280 | 1.4% |
| Other values (22) | 192089 | 7.5% |
| Value | Count | Frequency (%) |
| 1171393.493 | 3198 | 0.1% |
| 1212095.342 | 572599 | |
| 1243626.566 | 793 | < 0.1% |
| 1307811.243 | 4018 | 0.2% |
| 1310843.249 | 5591 | 0.2% |
| 1348154.753 | 4285 | 0.2% |
| 1388253.883 | 18671 | 0.7% |
| 1404703.587 | 59121 | 2.3% |
| 1417425.912 | 39420 | 1.5% |
| 1434209.509 | 20181 | 0.8% |
| Value | Count | Frequency (%) |
| 2593275.96 | 159 | < 0.1% |
| 2229208.752 | 16 | < 0.1% |
| 2107813.959 | 226327 | 8.8% |
| 2004599.926 | 26107 | 1.0% |
| 1901364.142 | 8184 | 0.3% |
| 1866250.314 | 234 | < 0.1% |
| 1839749.174 | 50586 | 2.0% |
| 1831205.93 | 33648 | 1.3% |
| 1821178.566 | 132899 | 5.2% |
| 1801097.339 | 739403 |
porcentaje_urbano
Real number (ℝ)
High correlation 
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4954 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 84.754443 |
| Minimum | 67.91 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 67.91 |
|---|---|
| 5-th percentile | 80.7 |
| Q1 | 83.79 |
| median | 86.48 |
| Q3 | 86.88 |
| 95-th percentile | 87.94 |
| Maximum | 100 |
| Range | 32.09 |
| Interquartile range (IQR) | 3.09 |
Descriptive statistics
| Standard deviation | 4.5114472 |
|---|---|
| Coefficient of variation (CV) | 0.053229625 |
| Kurtosis | 6.7473447 |
| Mean | 84.754443 |
| Median Absolute Deviation (MAD) | 1.69 |
| Skewness | -1.7625147 |
| Sum | 2.172909 × 108 |
| Variance | 20.353156 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 86.88 | 739403 | |
| 84.79 | 572599 | |
| 80.7 | 407942 | |
| 87.64 | 226327 | 8.8% |
| 87.94 | 132899 | 5.2% |
| 67.91 | 107104 | 4.2% |
| 87.54 | 59121 | 2.3% |
| 83.43 | 50586 | 2.0% |
| 83.79 | 39420 | 1.5% |
| 84.45 | 36280 | 1.4% |
| Other values (14) | 192089 | 7.5% |
| Value | Count | Frequency (%) |
| 67.91 | 107104 | 4.2% |
| 80.7 | 407942 | |
| 83.12 | 4285 | 0.2% |
| 83.43 | 50586 | 2.0% |
| 83.56 | 33648 | 1.3% |
| 83.79 | 39420 | 1.5% |
| 84.26 | 1034 | < 0.1% |
| 84.45 | 36280 | 1.4% |
| 84.79 | 572599 | |
| 85.64 | 20181 | 0.8% |
| Value | Count | Frequency (%) |
| 100 | 28710 | 1.1% |
| 97.5 | 159 | < 0.1% |
| 88.81 | 31109 | 1.2% |
| 88.75 | 5574 | 0.2% |
| 88.46 | 27727 | 1.1% |
| 87.94 | 132899 | 5.2% |
| 87.64 | 226327 | 8.8% |
| 87.54 | 59121 | 2.3% |
| 87.09 | 18671 | 0.7% |
| 86.88 | 739403 |
IPUG
Real number (ℝ)
High correlation 
| Distinct | 25 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 840471.69 |
| Minimum | 395366 |
|---|---|
| Maximum | 1935816 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 395366 |
|---|---|
| 5-th percentile | 395366 |
| Q1 | 595819 |
| median | 956065 |
| Q3 | 1056184 |
| 95-th percentile | 1250932 |
| Maximum | 1935816 |
| Range | 1540450 |
| Interquartile range (IQR) | 460365 |
Descriptive statistics
| Standard deviation | 288446.6 |
|---|---|
| Coefficient of variation (CV) | 0.3431961 |
| Kurtosis | -1.1850811 |
| Mean | 840471.69 |
| Median Absolute Deviation (MAD) | 185607 |
| Skewness | -0.41928982 |
| Sum | 2.1589356 × 1012 |
| Variance | 8.3201443 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1056184 | 739403 | |
| 395366 | 572599 | |
| 770458 | 407942 | |
| 1250932 | 226327 | 8.8% |
| 1049362 | 132899 | 5.2% |
| 1096893 | 107104 | 4.2% |
| 753265 | 59121 | 2.3% |
| 811720 | 50586 | 2.0% |
| 595819 | 39420 | 1.5% |
| 684916 | 36280 | 1.4% |
| Other values (15) | 197038 | 7.7% |
| Value | Count | Frequency (%) |
| 395366 | 572599 | |
| 416159 | 4949 | 0.2% |
| 529491 | 3198 | 0.1% |
| 550320 | 28710 | 1.1% |
| 565106 | 4285 | 0.2% |
| 585909 | 4018 | 0.2% |
| 595819 | 39420 | 1.5% |
| 612838 | 5591 | 0.2% |
| 643962 | 1034 | < 0.1% |
| 680424 | 18671 | 0.7% |
| Value | Count | Frequency (%) |
| 1935816 | 159 | < 0.1% |
| 1250932 | 226327 | 8.8% |
| 1102287 | 27727 | 1.1% |
| 1096893 | 107104 | 4.2% |
| 1082481 | 8184 | 0.3% |
| 1056184 | 739403 | |
| 1049362 | 132899 | 5.2% |
| 1002858 | 5574 | 0.2% |
| 980735 | 31109 | 1.2% |
| 956065 | 33648 | 1.3% |
GINI
Real number (ℝ)
High correlation 
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5143927 |
| Minimum | 0.442 |
|---|---|
| Maximum | 0.95 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 0.442 |
|---|---|
| 5-th percentile | 0.471 |
| Q1 | 0.501 |
| median | 0.512 |
| Q3 | 0.524 |
| 95-th percentile | 0.536 |
| Maximum | 0.95 |
| Range | 0.508 |
| Interquartile range (IQR) | 0.023 |
Descriptive statistics
| Standard deviation | 0.038863934 |
|---|---|
| Coefficient of variation (CV) | 0.075553044 |
| Kurtosis | 48.723919 |
| Mean | 0.5143927 |
| Median Absolute Deviation (MAD) | 0.011 |
| Skewness | 6.0249114 |
| Sum | 1321330.3 |
| Variance | 0.0015104054 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.501 | 739403 | |
| 0.536 | 572599 | |
| 0.518 | 407942 | |
| 0.524 | 226327 | 8.8% |
| 0.471 | 225668 | 8.8% |
| 0.506 | 107104 | 4.2% |
| 0.512 | 58091 | 2.3% |
| 0.498 | 50586 | 2.0% |
| 0.472 | 36280 | 1.4% |
| 0.486 | 31109 | 1.2% |
| Other values (18) | 113610 | 4.4% |
| Value | Count | Frequency (%) |
| 0.442 | 1034 | < 0.1% |
| 0.465 | 5574 | 0.2% |
| 0.471 | 225668 | |
| 0.472 | 36280 | 1.4% |
| 0.486 | 31109 | 1.2% |
| 0.487 | 5591 | 0.2% |
| 0.491 | 8184 | 0.3% |
| 0.492 | 3198 | 0.1% |
| 0.497 | 20181 | 0.8% |
| 0.498 | 50586 | 2.0% |
| Value | Count | Frequency (%) |
| 0.95 | 180 | < 0.1% |
| 0.84 | 26107 | 1.0% |
| 0.71 | 1176 | < 0.1% |
| 0.67 | 234 | < 0.1% |
| 0.589 | 4949 | 0.2% |
| 0.56 | 43 | < 0.1% |
| 0.54 | 793 | < 0.1% |
| 0.536 | 572599 | |
| 0.53 | 159 | < 0.1% |
| 0.524 | 226327 | 8.8% |
total_productos
Real number (ℝ)
High correlation  Skewed 
| Distinct | 71035 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4404.9228 |
| Minimum | 0.4 |
|---|---|
| Maximum | 2070111.4 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 0.4 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 28.44 |
| median | 163.2 |
| Q3 | 581.94 |
| 95-th percentile | 2639.32 |
| Maximum | 2070111.4 |
| Range | 2070111 |
| Interquartile range (IQR) | 553.5 |
Descriptive statistics
| Standard deviation | 73699.706 |
|---|---|
| Coefficient of variation (CV) | 16.731214 |
| Kurtosis | 590.18325 |
| Mean | 4404.9228 |
| Median Absolute Deviation (MAD) | 156.45 |
| Skewness | 23.569078 |
| Sum | 1.1315031 × 1010 |
| Variance | 5.4316466 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 62574 | 2.4% |
| 2 | 60029 | 2.3% |
| 3 | 44612 | 1.7% |
| 4 | 38760 | 1.5% |
| 5 | 28895 | 1.1% |
| 6 | 25611 | 1.0% |
| 7 | 18681 | 0.7% |
| 8 | 17326 | 0.7% |
| 9 | 13568 | 0.5% |
| 10 | 13295 | 0.5% |
| Other values (71025) | 2245373 |
| Value | Count | Frequency (%) |
| 0.4 | 6 | < 0.1% |
| 0.48 | 14 | < 0.1% |
| 0.52 | 5 | < 0.1% |
| 0.54 | 2 | < 0.1% |
| 0.8 | 4 | < 0.1% |
| 0.84 | 4 | < 0.1% |
| 0.96 | 11 | < 0.1% |
| 0.98 | 1 | < 0.1% |
| 1 | 62574 | |
| 1.02 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2070111.4 | 1555 | |
| 1733209.4 | 1671 | |
| 1140865.5 | 94 | < 0.1% |
| 1021267.8 | 38 | < 0.1% |
| 952663.2 | 1735 | |
| 523610.44 | 1361 | |
| 504107 | 26 | < 0.1% |
| 442087.66 | 55 | < 0.1% |
| 336561 | 45 | < 0.1% |
| 331882.56 | 51 | < 0.1% |
total_gasto
Real number (ℝ)
High correlation 
| Distinct | 93148 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3188.546 |
| Minimum | 0.07 |
|---|---|
| Maximum | 912072.44 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 0.07 |
|---|---|
| 5-th percentile | 10.849999 |
| Q1 | 77.380005 |
| median | 247.9 |
| Q3 | 636.31995 |
| 95-th percentile | 3023.46 |
| Maximum | 912072.44 |
| Range | 912072.37 |
| Interquartile range (IQR) | 558.93994 |
Descriptive statistics
| Standard deviation | 41173.977 |
|---|---|
| Coefficient of variation (CV) | 12.913088 |
| Kurtosis | 350.93192 |
| Mean | 3188.546 |
| Median Absolute Deviation (MAD) | 204.95 |
| Skewness | 18.33987 |
| Sum | 8.1904947 × 109 |
| Variance | 1.6952963 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 812211.94 | 1735 | 0.1% |
| 912072.44 | 1671 | 0.1% |
| 757335.44 | 1555 | 0.1% |
| 464574.28 | 1361 | 0.1% |
| 573531.44 | 1318 | 0.1% |
| 12543.24 | 1173 | < 0.1% |
| 1.13 | 1155 | < 0.1% |
| 19.88 | 1134 | < 0.1% |
| 18.47 | 1080 | < 0.1% |
| 1.2 | 1033 | < 0.1% |
| Other values (93138) | 2555509 |
| Value | Count | Frequency (%) |
| 0.07 | 2 | < 0.1% |
| 0.09 | 1 | < 0.1% |
| 0.12 | 1 | < 0.1% |
| 0.13 | 1 | < 0.1% |
| 0.15 | 3 | |
| 0.24 | 5 | |
| 0.25 | 1 | < 0.1% |
| 0.26 | 5 | |
| 0.27 | 5 | |
| 0.28 | 6 |
| Value | Count | Frequency (%) |
| 912072.44 | 1671 | |
| 812211.94 | 1735 | |
| 757335.44 | 1555 | |
| 573531.44 | 1318 | |
| 464574.28 | 1361 | |
| 396370.2 | 945 | |
| 247083.06 | 644 | < 0.1% |
| 186000.83 | 94 | < 0.1% |
| 149620.8 | 181 | < 0.1% |
| 129457.25 | 461 | < 0.1% |
precio_promedio
Real number (ℝ)
High correlation  Skewed 
| Distinct | 260446 |
|---|---|
| Distinct (%) | 10.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.4421912 |
| Minimum | 0.0039547062 |
|---|---|
| Maximum | 2177.81 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 0.0039547062 |
|---|---|
| 5-th percentile | 0.38869548 |
| Q1 | 0.6737593 |
| median | 1.5778431 |
| Q3 | 3.6011639 |
| 95-th percentile | 19.027935 |
| Maximum | 2177.81 |
| Range | 2177.806 |
| Interquartile range (IQR) | 2.9274046 |
Descriptive statistics
| Standard deviation | 10.496226 |
|---|---|
| Coefficient of variation (CV) | 2.3628488 |
| Kurtosis | 2438.0341 |
| Mean | 4.4421912 |
| Median Absolute Deviation (MAD) | 1.0798431 |
| Skewness | 24.843452 |
| Sum | 11410763 |
| Variance | 110.17076 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.85257 | 1735 | 0.1% |
| 0.52623326 | 1671 | 0.1% |
| 0.36584282 | 1555 | 0.1% |
| 0.6 | 1415 | 0.1% |
| 0.65 | 1378 | 0.1% |
| 0.88725173 | 1361 | 0.1% |
| 3.1338317 | 1318 | 0.1% |
| 0.565 | 1300 | 0.1% |
| 2.9663782 | 1173 | < 0.1% |
| 18.47 | 1142 | < 0.1% |
| Other values (260436) | 2554676 |
| Value | Count | Frequency (%) |
| 0.0039547062 | 1 | < 0.1% |
| 0.00685977 | 6 | < 0.1% |
| 0.0073786806 | 9 | < 0.1% |
| 0.007571423 | 7 | < 0.1% |
| 0.008853219 | 9 | < 0.1% |
| 0.009492378 | 13 | < 0.1% |
| 0.015799172 | 111 | |
| 0.016728375 | 17 | < 0.1% |
| 0.018946793 | 71 | |
| 0.024560008 | 33 | < 0.1% |
| Value | Count | Frequency (%) |
| 2177.81 | 1 | < 0.1% |
| 1703.4 | 1 | < 0.1% |
| 1607.53 | 1 | < 0.1% |
| 1437.48 | 3 | |
| 1408.16 | 2 | |
| 1010.53 | 1 | < 0.1% |
| 849.62 | 1 | < 0.1% |
| 821.0675 | 4 | |
| 795.42 | 2 | |
| 795.01 | 1 | < 0.1% |
num_pedidos
Real number (ℝ)
High correlation 
| Distinct | 128 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.5446296 |
| Minimum | 1 |
|---|---|
| Maximum | 1133 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 6 |
| 95-th percentile | 20 |
| Maximum | 1133 |
| Range | 1132 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 56.246915 |
|---|---|
| Coefficient of variation (CV) | 5.8930433 |
| Kurtosis | 276.17543 |
| Mean | 9.5446296 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 15.946754 |
| Sum | 24517519 |
| Variance | 3163.7154 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 610854 | |
| 2 | 464762 | |
| 3 | 334652 | |
| 4 | 241867 | 9.4% |
| 5 | 177691 | 6.9% |
| 6 | 130856 | 5.1% |
| 7 | 100684 | 3.9% |
| 8 | 76597 | 3.0% |
| 9 | 59873 | 2.3% |
| 10 | 48727 | 1.9% |
| Other values (118) | 322161 |
| Value | Count | Frequency (%) |
| 1 | 610854 | |
| 2 | 464762 | |
| 3 | 334652 | |
| 4 | 241867 | 9.4% |
| 5 | 177691 | 6.9% |
| 6 | 130856 | 5.1% |
| 7 | 100684 | 3.9% |
| 8 | 76597 | 3.0% |
| 9 | 59873 | 2.3% |
| 10 | 48727 | 1.9% |
| Value | Count | Frequency (%) |
| 1133 | 1735 | |
| 1029 | 1671 | |
| 1015 | 1555 | |
| 860 | 1361 | |
| 562 | 1173 | |
| 559 | 945 | |
| 485 | 1318 | |
| 404 | 998 | |
| 348 | 644 | < 0.1% |
| 312 | 318 | < 0.1% |
ticket_promedio
Real number (ℝ)
High correlation 
| Distinct | 131307 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 121.69413 |
| Minimum | 0.07 |
|---|---|
| Maximum | 18707.72 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 0.07 |
|---|---|
| 5-th percentile | 7.455 |
| Q1 | 32.17575 |
| median | 71.64333 |
| Q3 | 142.26875 |
| 95-th percentile | 382.50497 |
| Maximum | 18707.72 |
| Range | 18707.65 |
| Interquartile range (IQR) | 110.093 |
Descriptive statistics
| Standard deviation | 200.62754 |
|---|---|
| Coefficient of variation (CV) | 1.6486213 |
| Kurtosis | 604.72823 |
| Mean | 121.69413 |
| Median Absolute Deviation (MAD) | 47.34833 |
| Skewness | 14.452625 |
| Sum | 3.1259864 × 108 |
| Variance | 40251.409 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 716.8684 | 1735 | 0.1% |
| 886.3678 | 1671 | 0.1% |
| 746.1433 | 1555 | 0.1% |
| 540.20264 | 1361 | 0.1% |
| 1182.5391 | 1318 | 0.1% |
| 1.13 | 1257 | < 0.1% |
| 19.88 | 1184 | < 0.1% |
| 22.318933 | 1173 | < 0.1% |
| 1.2 | 1141 | < 0.1% |
| 18.47 | 1121 | < 0.1% |
| Other values (131297) | 2555208 |
| Value | Count | Frequency (%) |
| 0.07 | 2 | < 0.1% |
| 0.09 | 1 | < 0.1% |
| 0.12 | 1 | < 0.1% |
| 0.13 | 1 | < 0.1% |
| 0.15 | 3 | |
| 0.24 | 5 | |
| 0.25 | 1 | < 0.1% |
| 0.26 | 5 | |
| 0.27 | 5 | |
| 0.28 | 6 |
| Value | Count | Frequency (%) |
| 18707.72 | 2 | < 0.1% |
| 18029.578 | 6 | < 0.1% |
| 17066.71 | 5 | < 0.1% |
| 12910.56 | 2 | < 0.1% |
| 11729.96 | 3 | < 0.1% |
| 8857.183 | 94 | |
| 8598.75 | 13 | < 0.1% |
| 7946.05 | 24 | < 0.1% |
| 7676.9 | 1 | < 0.1% |
| 7607.127 | 3 | < 0.1% |
cantidad_promedio
Real number (ℝ)
High correlation  Skewed 
| Distinct | 94247 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 121.55906 |
| Minimum | 0.4 |
|---|---|
| Maximum | 100145.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 0.4 |
|---|---|
| 5-th percentile | 1.6666666 |
| Q1 | 10.28 |
| median | 44.787777 |
| Q3 | 128.6355 |
| 95-th percentile | 435.4 |
| Maximum | 100145.5 |
| Range | 100145.1 |
| Interquartile range (IQR) | 118.3555 |
Descriptive statistics
| Standard deviation | 495.7702 |
|---|---|
| Coefficient of variation (CV) | 4.0784305 |
| Kurtosis | 8129.2788 |
| Mean | 121.55906 |
| Median Absolute Deviation (MAD) | 40.787777 |
| Skewness | 73.019714 |
| Sum | 3.1225168 × 108 |
| Variance | 245788.09 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 79745 | 3.1% |
| 2 | 66342 | 2.6% |
| 3 | 41844 | 1.6% |
| 4 | 30425 | 1.2% |
| 5 | 20488 | 0.8% |
| 6 | 16541 | 0.6% |
| 1.5 | 14438 | 0.6% |
| 2.5 | 10913 | 0.4% |
| 7 | 9654 | 0.4% |
| 8 | 8261 | 0.3% |
| Other values (94237) | 2270073 |
| Value | Count | Frequency (%) |
| 0.4 | 8 | |
| 0.48 | 18 | |
| 0.52 | 5 | < 0.1% |
| 0.54 | 2 | < 0.1% |
| 0.6 | 2 | < 0.1% |
| 0.665 | 2 | < 0.1% |
| 0.7 | 2 | < 0.1% |
| 0.71999997 | 2 | < 0.1% |
| 0.74 | 4 | < 0.1% |
| 0.8 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 100145.5 | 3 | < 0.1% |
| 54326.93 | 94 | |
| 42008.918 | 26 | < 0.1% |
| 40013 | 6 | < 0.1% |
| 31914.62 | 38 | |
| 18227.256 | 53 | |
| 17085.857 | 9 | < 0.1% |
| 17000 | 1 | < 0.1% |
| 16638 | 7 | < 0.1% |
| 15244.402 | 55 |
categorias_diferentes
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 122.5 MiB |
| 1 | |
|---|---|
| 2 | |
| 3 | |
| 4 | |
| 5 | 26502 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 942232 | |
| 2 | 869680 | |
| 3 | 528945 | |
| 4 | 201365 | 7.8% |
| 5 | 26502 | 1.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 942232 | |
| 2 | 869680 | |
| 3 | 528945 | |
| 4 | 201365 | 7.8% |
| 5 | 26502 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 942232 | |
| 2 | 869680 | |
| 3 | 528945 | |
| 4 | 201365 | 7.8% |
| 5 | 26502 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2568724 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 942232 | |
| 2 | 869680 | |
| 3 | 528945 | |
| 4 | 201365 | 7.8% |
| 5 | 26502 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2568724 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 942232 | |
| 2 | 869680 | |
| 3 | 528945 | |
| 4 | 201365 | 7.8% |
| 5 | 26502 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2568724 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 942232 | |
| 2 | 869680 | |
| 3 | 528945 | |
| 4 | 201365 | 7.8% |
| 5 | 26502 | 1.0% |
Total de edificaciones en obra
Real number (ℝ)
Zeros 
| Distinct | 92 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.9911559 |
| Minimum | 0 |
|---|---|
| Maximum | 654 |
| Zeros | 678206 |
| Zeros (%) | 26.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 27 |
| Maximum | 654 |
| Range | 654 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 35.698612 |
|---|---|
| Coefficient of variation (CV) | 3.9704141 |
| Kurtosis | 124.03997 |
| Mean | 8.9911559 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 10.876594 |
| Sum | 23095798 |
| Variance | 1274.3909 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 678206 | |
| 6 | 610549 | |
| 1 | 303926 | |
| 3 | 220156 | 8.6% |
| 10 | 143655 | 5.6% |
| 16 | 142501 | 5.5% |
| 27 | 77243 | 3.0% |
| 2 | 66825 | 2.6% |
| 13 | 59062 | 2.3% |
| 5 | 47566 | 1.9% |
| Other values (82) | 219035 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 678206 | |
| 1 | 303926 | |
| 2 | 66825 | 2.6% |
| 3 | 220156 | 8.6% |
| 4 | 35704 | 1.4% |
| 5 | 47566 | 1.9% |
| 6 | 610549 | |
| 7 | 39016 | 1.5% |
| 8 | 6103 | 0.2% |
| 9 | 18646 | 0.7% |
| Value | Count | Frequency (%) |
| 654 | 69 | < 0.1% |
| 451 | 395 | < 0.1% |
| 425 | 16697 | |
| 367 | 37 | < 0.1% |
| 299 | 70 | < 0.1% |
| 251 | 2 | < 0.1% |
| 223 | 6 | < 0.1% |
| 215 | 238 | < 0.1% |
| 202 | 162 | < 0.1% |
| 190 | 558 | < 0.1% |
Interactions
Correlations
| GINI | IPUG | Total de edificaciones en obra | ajustada_alineacion | alineación con portafolio estratégico | cantidad | cantidad_promedio | categoria | categoria_macro | categorias_diferentes | cluster | edad | edad_promedio | id | ingreso_laboral_promedio | log_cantidad | log_precio | log_valor | num_pedidos | pedido | porcentaje_urbano | precio | precio_promedio | ticket_promedio | total_gasto | total_productos | valor | zona | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GINI | 1.000 | -0.466 | -0.103 | -0.040 | -0.040 | -0.014 | -0.016 | 0.029 | 0.031 | 0.020 | 0.093 | -0.022 | -0.383 | 0.003 | -0.520 | -0.014 | -0.023 | -0.043 | 0.015 | -0.004 | -0.321 | -0.023 | -0.041 | -0.069 | -0.036 | -0.006 | -0.043 | 1.000 |
| IPUG | -0.466 | 1.000 | 0.161 | 0.020 | 0.020 | 0.005 | 0.017 | 0.048 | 0.041 | 0.048 | 0.198 | 0.043 | 0.532 | 0.002 | 0.800 | 0.005 | 0.007 | 0.022 | -0.019 | 0.005 | 0.442 | 0.007 | 0.029 | 0.060 | 0.031 | 0.007 | 0.022 | 1.000 |
| Total de edificaciones en obra | -0.103 | 0.161 | 1.000 | -0.000 | -0.000 | -0.004 | -0.015 | 0.007 | 0.007 | 0.009 | 0.035 | -0.001 | -0.219 | 0.006 | 0.118 | -0.004 | 0.001 | 0.001 | -0.018 | -0.003 | 0.286 | 0.001 | 0.010 | -0.010 | -0.019 | -0.020 | 0.001 | 0.401 |
| ajustada_alineacion | -0.040 | 0.020 | -0.000 | 1.000 | 1.000 | 0.366 | 0.182 | 0.025 | 0.015 | 0.006 | 0.048 | -0.067 | 0.018 | -0.059 | 0.037 | 0.366 | 0.493 | 0.982 | 0.093 | -0.006 | 0.013 | 0.493 | 0.101 | 0.368 | 0.307 | 0.188 | 0.982 | 0.005 |
| alineación con portafolio estratégico | -0.040 | 0.020 | -0.000 | 1.000 | 1.000 | 0.366 | 0.182 | 0.026 | 0.017 | 0.005 | 0.053 | -0.067 | 0.018 | -0.059 | 0.037 | 0.366 | 0.493 | 0.982 | 0.093 | -0.006 | 0.013 | 0.493 | 0.101 | 0.368 | 0.307 | 0.188 | 0.982 | 0.004 |
| cantidad | -0.014 | 0.005 | -0.004 | 0.366 | 0.366 | 1.000 | 0.420 | 0.036 | 0.006 | 0.003 | 0.064 | -0.039 | 0.008 | -0.057 | 0.014 | 1.000 | -0.530 | 0.387 | 0.076 | -0.011 | -0.014 | -0.530 | -0.390 | 0.212 | 0.187 | 0.355 | 0.387 | 0.006 |
| cantidad_promedio | -0.016 | 0.017 | -0.015 | 0.182 | 0.182 | 0.420 | 1.000 | 0.048 | 0.013 | 0.016 | 0.085 | -0.077 | 0.024 | -0.120 | 0.034 | 0.420 | -0.234 | 0.188 | 0.221 | -0.002 | -0.035 | -0.234 | -0.725 | 0.697 | 0.602 | 0.875 | 0.188 | 0.034 |
| categoria | 0.029 | 0.048 | 0.007 | 0.025 | 0.026 | 0.036 | 0.048 | 1.000 | 1.000 | 0.155 | 0.086 | 0.039 | 0.042 | 0.025 | 0.035 | 0.258 | 0.474 | 0.235 | 0.058 | 0.015 | 0.040 | 0.060 | 0.120 | 0.019 | 0.033 | 0.030 | 0.017 | 0.031 |
| categoria_macro | 0.031 | 0.041 | 0.007 | 0.015 | 0.017 | 0.006 | 0.013 | 1.000 | 1.000 | 0.126 | 0.087 | 0.026 | 0.043 | 0.021 | 0.031 | 0.322 | 0.356 | 0.101 | 0.057 | 0.018 | 0.034 | 0.043 | 0.014 | 0.011 | 0.024 | 0.018 | 0.004 | 0.055 |
| categorias_diferentes | 0.020 | 0.048 | 0.009 | 0.006 | 0.005 | 0.003 | 0.016 | 0.155 | 0.126 | 1.000 | 0.089 | 0.049 | 0.049 | 0.150 | 0.034 | 0.051 | 0.078 | 0.044 | 0.106 | 0.023 | 0.049 | 0.020 | 0.006 | 0.014 | 0.087 | 0.082 | 0.008 | 0.070 |
| cluster | 0.093 | 0.198 | 0.035 | 0.048 | 0.053 | 0.064 | 0.085 | 0.086 | 0.087 | 0.089 | 1.000 | 0.055 | 0.181 | 0.040 | 0.118 | 0.068 | 0.061 | 0.088 | 0.203 | 0.015 | 0.150 | 0.032 | 0.010 | 0.072 | 0.226 | 0.210 | 0.055 | 0.244 |
| edad | -0.022 | 0.043 | -0.001 | -0.067 | -0.067 | -0.039 | -0.077 | 0.039 | 0.026 | 0.049 | 0.055 | 1.000 | 0.040 | 0.057 | 0.025 | -0.039 | -0.029 | -0.068 | -0.080 | -0.002 | 0.021 | -0.029 | -0.017 | -0.129 | -0.139 | -0.104 | -0.068 | 0.089 |
| edad_promedio | -0.383 | 0.532 | -0.219 | 0.018 | 0.018 | 0.008 | 0.024 | 0.042 | 0.043 | 0.049 | 0.181 | 0.040 | 1.000 | -0.008 | 0.616 | 0.008 | 0.006 | 0.016 | 0.015 | 0.009 | 0.141 | 0.006 | 0.007 | 0.047 | 0.044 | 0.029 | 0.016 | 1.000 |
| id | 0.003 | 0.002 | 0.006 | -0.059 | -0.059 | -0.057 | -0.120 | 0.025 | 0.021 | 0.150 | 0.040 | 0.057 | -0.008 | 1.000 | -0.011 | -0.057 | -0.009 | -0.061 | -0.505 | 0.524 | 0.018 | -0.009 | 0.051 | -0.108 | -0.386 | -0.336 | -0.061 | 0.034 |
| ingreso_laboral_promedio | -0.520 | 0.800 | 0.118 | 0.037 | 0.037 | 0.014 | 0.034 | 0.035 | 0.031 | 0.034 | 0.118 | 0.025 | 0.616 | -0.011 | 1.000 | 0.014 | 0.016 | 0.040 | -0.000 | 0.006 | 0.570 | 0.016 | 0.031 | 0.087 | 0.057 | 0.027 | 0.040 | 1.000 |
| log_cantidad | -0.014 | 0.005 | -0.004 | 0.366 | 0.366 | 1.000 | 0.420 | 0.258 | 0.322 | 0.051 | 0.068 | -0.039 | 0.008 | -0.057 | 0.014 | 1.000 | -0.530 | 0.387 | 0.076 | -0.011 | -0.014 | -0.530 | -0.390 | 0.212 | 0.187 | 0.355 | 0.387 | 0.038 |
| log_precio | -0.023 | 0.007 | 0.001 | 0.493 | 0.493 | -0.530 | -0.234 | 0.474 | 0.356 | 0.078 | 0.061 | -0.029 | 0.006 | -0.009 | 0.016 | -0.530 | 1.000 | 0.485 | 0.029 | 0.006 | 0.019 | 1.000 | 0.432 | 0.092 | 0.085 | -0.162 | 0.485 | 0.025 |
| log_valor | -0.043 | 0.022 | 0.001 | 0.982 | 0.982 | 0.387 | 0.188 | 0.235 | 0.101 | 0.044 | 0.088 | -0.068 | 0.016 | -0.061 | 0.040 | 0.387 | 0.485 | 1.000 | 0.091 | -0.006 | 0.009 | 0.485 | 0.086 | 0.360 | 0.300 | 0.192 | 1.000 | 0.064 |
| num_pedidos | 0.015 | -0.019 | -0.018 | 0.093 | 0.093 | 0.076 | 0.221 | 0.058 | 0.057 | 0.106 | 0.203 | -0.080 | 0.015 | -0.505 | -0.000 | 0.076 | 0.029 | 0.091 | 1.000 | 0.016 | -0.038 | 0.029 | -0.110 | 0.178 | 0.721 | 0.629 | 0.091 | 0.180 |
| pedido | -0.004 | 0.005 | -0.003 | -0.006 | -0.006 | -0.011 | -0.002 | 0.015 | 0.018 | 0.023 | 0.015 | -0.002 | 0.009 | 0.524 | 0.006 | -0.011 | 0.006 | -0.006 | 0.016 | 1.000 | -0.001 | 0.006 | 0.003 | -0.000 | 0.009 | 0.006 | -0.006 | 0.014 |
| porcentaje_urbano | -0.321 | 0.442 | 0.286 | 0.013 | 0.013 | -0.014 | -0.035 | 0.040 | 0.034 | 0.049 | 0.150 | 0.021 | 0.141 | 0.018 | 0.570 | -0.014 | 0.019 | 0.009 | -0.038 | -0.001 | 1.000 | 0.019 | 0.049 | 0.007 | -0.017 | -0.042 | 0.009 | 1.000 |
| precio | -0.023 | 0.007 | 0.001 | 0.493 | 0.493 | -0.530 | -0.234 | 0.060 | 0.043 | 0.020 | 0.032 | -0.029 | 0.006 | -0.009 | 0.016 | -0.530 | 1.000 | 0.485 | 0.029 | 0.006 | 0.019 | 1.000 | 0.432 | 0.092 | 0.085 | -0.162 | 0.485 | 0.000 |
| precio_promedio | -0.041 | 0.029 | 0.010 | 0.101 | 0.101 | -0.390 | -0.725 | 0.120 | 0.014 | 0.006 | 0.010 | -0.017 | 0.007 | 0.051 | 0.031 | -0.390 | 0.432 | 0.086 | -0.110 | 0.003 | 0.049 | 0.432 | 1.000 | -0.066 | -0.104 | -0.611 | 0.086 | 0.005 |
| ticket_promedio | -0.069 | 0.060 | -0.010 | 0.368 | 0.368 | 0.212 | 0.697 | 0.019 | 0.011 | 0.014 | 0.072 | -0.129 | 0.047 | -0.108 | 0.087 | 0.212 | 0.092 | 0.360 | 0.178 | -0.000 | 0.007 | 0.092 | -0.066 | 1.000 | 0.780 | 0.627 | 0.360 | 0.042 |
| total_gasto | -0.036 | 0.031 | -0.019 | 0.307 | 0.307 | 0.187 | 0.602 | 0.033 | 0.024 | 0.087 | 0.226 | -0.139 | 0.044 | -0.386 | 0.057 | 0.187 | 0.085 | 0.300 | 0.721 | 0.009 | -0.017 | 0.085 | -0.104 | 0.780 | 1.000 | 0.824 | 0.300 | 0.197 |
| total_productos | -0.006 | 0.007 | -0.020 | 0.188 | 0.188 | 0.355 | 0.875 | 0.030 | 0.018 | 0.082 | 0.210 | -0.104 | 0.029 | -0.336 | 0.027 | 0.355 | -0.162 | 0.192 | 0.629 | 0.006 | -0.042 | -0.162 | -0.611 | 0.627 | 0.824 | 1.000 | 0.192 | 0.180 |
| valor | -0.043 | 0.022 | 0.001 | 0.982 | 0.982 | 0.387 | 0.188 | 0.017 | 0.004 | 0.008 | 0.055 | -0.068 | 0.016 | -0.061 | 0.040 | 0.387 | 0.485 | 1.000 | 0.091 | -0.006 | 0.009 | 0.485 | 0.086 | 0.360 | 0.300 | 0.192 | 1.000 | 0.027 |
| zona | 1.000 | 1.000 | 0.401 | 0.005 | 0.004 | 0.006 | 0.034 | 0.031 | 0.055 | 0.070 | 0.244 | 0.089 | 1.000 | 0.034 | 1.000 | 0.038 | 0.025 | 0.064 | 0.180 | 0.014 | 1.000 | 0.000 | 0.005 | 0.042 | 0.197 | 0.180 | 0.027 | 1.000 |
Missing values
Sample
| fecha | pedido | id | edad | municipio | zona | asesor | punto de venta | cluster | categoria_macro | categoria | subcategoria | producto | color | cantidad | precio | valor | alineación con portafolio estratégico | log_cantidad | log_precio | log_valor | ajustada_alineacion | edad_promedio | ingreso_laboral_promedio | porcentaje_urbano | IPUG | GINI | total_productos | total_gasto | precio_promedio | num_pedidos | ticket_promedio | cantidad_promedio | categorias_diferentes | Total de edificaciones en obra | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1971-04-30 | 2 | 2 | 52 | EL CARMEN DE CHUCURI | SANTANDER | asesor_2 | punto_venta_2 | cluster_tienda_2 | categoria_macro_1 | categoria_2 | subcategoria_2 | producto_2 | GRIS | 1.00 | 32.88 | 32.88 | 2.920320 | 0.693147 | 3.522825 | 3.522825 | -0.061772 | 37.077072 | 1.801097e+06 | 86.88 | 1056184.0 | 0.501 | 77.040000 | 389.13 | 5.051012 | 12 | 32.4275 | 6.420000 | 3 | 2.0 |
| 1 | 1971-04-30 | 3 | 3 | 31 | VILLANUEVA | LA GUAJIRA | asesor_3 | punto_venta_2 | cluster_tienda_2 | categoria_macro_2 | categoria_3 | subcategoria_3 | producto_3 | BEIGE | 2.00 | 0.56 | 1.13 | 0.117504 | 1.098612 | 0.444686 | 0.756122 | -0.201143 | 29.862683 | 1.212095e+06 | 84.79 | 395366.0 | 0.536 | 2.000000 | 1.13 | 0.565000 | 1 | 1.1300 | 2.000000 | 1 | 1.0 |
| 2 | 1971-04-30 | 3 | 3 | 31 | VILLANUEVA | LA GUAJIRA | asesor_3 | punto_venta_2 | cluster_tienda_2 | categoria_macro_2 | categoria_3 | subcategoria_3 | producto_3 | BEIGE | 2.00 | 0.56 | 1.13 | 0.117504 | 1.098612 | 0.444686 | 0.756122 | -0.201143 | 29.862683 | 1.212095e+06 | 84.79 | 395366.0 | 0.536 | 2.000000 | 1.13 | 0.565000 | 1 | 1.1300 | 2.000000 | 1 | 10.0 |
| 3 | 1971-04-30 | 3 | 3 | 31 | VILLANUEVA | LA GUAJIRA | asesor_3 | punto_venta_2 | cluster_tienda_2 | categoria_macro_2 | categoria_3 | subcategoria_3 | producto_3 | BEIGE | 2.00 | 0.56 | 1.13 | 0.117504 | 1.098612 | 0.444686 | 0.756122 | -0.201143 | 29.862683 | 1.212095e+06 | 84.79 | 395366.0 | 0.536 | 2.000000 | 1.13 | 0.565000 | 1 | 1.1300 | 2.000000 | 1 | 16.0 |
| 4 | 1971-04-30 | 3 | 3 | 31 | VILLANUEVA | LA GUAJIRA | asesor_3 | punto_venta_2 | cluster_tienda_2 | categoria_macro_2 | categoria_3 | subcategoria_3 | producto_3 | BEIGE | 2.00 | 0.56 | 1.13 | 0.117504 | 1.098612 | 0.444686 | 0.756122 | -0.201143 | 29.862683 | 1.212095e+06 | 84.79 | 395366.0 | 0.536 | 2.000000 | 1.13 | 0.565000 | 1 | 1.1300 | 2.000000 | 1 | 0.0 |
| 5 | 1971-04-30 | 4 | 4 | 43 | VILLANUEVA | LA GUAJIRA | asesor_4 | punto_venta_2 | cluster_tienda_2 | categoria_macro_3 | categoria_4 | subcategoria_4 | producto_4 | No encontrado | 1.00 | 8.38 | 8.38 | 1.251072 | 0.693147 | 2.238580 | 2.238580 | -0.145693 | 29.862683 | 1.212095e+06 | 84.79 | 395366.0 | 0.536 | 1.000000 | 8.38 | 8.380000 | 1 | 8.3800 | 1.000000 | 1 | 1.0 |
| 6 | 1971-04-30 | 4 | 4 | 43 | VILLANUEVA | LA GUAJIRA | asesor_4 | punto_venta_2 | cluster_tienda_2 | categoria_macro_3 | categoria_4 | subcategoria_4 | producto_4 | No encontrado | 1.00 | 8.38 | 8.38 | 1.251072 | 0.693147 | 2.238580 | 2.238580 | -0.145693 | 29.862683 | 1.212095e+06 | 84.79 | 395366.0 | 0.536 | 1.000000 | 8.38 | 8.380000 | 1 | 8.3800 | 1.000000 | 1 | 10.0 |
| 7 | 1971-04-30 | 4 | 4 | 43 | VILLANUEVA | LA GUAJIRA | asesor_4 | punto_venta_2 | cluster_tienda_2 | categoria_macro_3 | categoria_4 | subcategoria_4 | producto_4 | No encontrado | 1.00 | 8.38 | 8.38 | 1.251072 | 0.693147 | 2.238580 | 2.238580 | -0.145693 | 29.862683 | 1.212095e+06 | 84.79 | 395366.0 | 0.536 | 1.000000 | 8.38 | 8.380000 | 1 | 8.3800 | 1.000000 | 1 | 16.0 |
| 8 | 1971-04-30 | 4 | 4 | 43 | VILLANUEVA | LA GUAJIRA | asesor_4 | punto_venta_2 | cluster_tienda_2 | categoria_macro_3 | categoria_4 | subcategoria_4 | producto_4 | No encontrado | 1.00 | 8.38 | 8.38 | 1.251072 | 0.693147 | 2.238580 | 2.238580 | -0.145693 | 29.862683 | 1.212095e+06 | 84.79 | 395366.0 | 0.536 | 1.000000 | 8.38 | 8.380000 | 1 | 8.3800 | 1.000000 | 1 | 0.0 |
| 9 | 1971-04-30 | 5 | 5 | 31 | VILLANUEVA | LA GUAJIRA | asesor_5 | punto_venta_3 | cluster_tienda_3 | categoria_macro_2 | categoria_5 | subcategoria_5 | producto_5 | BLANCO | 21.14 | 2.27 | 47.99 | 3.729024 | 3.097386 | 1.184790 | 3.891616 | -0.020477 | 29.862683 | 1.212095e+06 | 84.79 | 395366.0 | 0.536 | 54.809998 | 73.50 | 1.340996 | 3 | 24.5000 | 18.269999 | 2 | 1.0 |
| fecha | pedido | id | edad | municipio | zona | asesor | punto de venta | cluster | categoria_macro | categoria | subcategoria | producto | color | cantidad | precio | valor | alineación con portafolio estratégico | log_cantidad | log_precio | log_valor | ajustada_alineacion | edad_promedio | ingreso_laboral_promedio | porcentaje_urbano | IPUG | GINI | total_productos | total_gasto | precio_promedio | num_pedidos | ticket_promedio | cantidad_promedio | categorias_diferentes | Total de edificaciones en obra | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2568714 | 1972-09-01 | 933930 | 419221 | 29 | CURITI | SANTANDER | asesor_380 | punto_venta_10 | cluster_tienda_3 | categoria_macro_1 | categoria_1 | subcategoria_26 | producto_410 | No encontrado | 1.00 | 0.92 | 0.92 | 0.082944 | 0.693147 | 0.652325 | 0.652325 | -0.202803 | 37.077072 | 1.801097e+06 | 86.88 | 1056184.0 | 0.501 | 41.240000 | 93.65000 | 2.270853 | 3 | 31.216667 | 13.746667 | 3 | 6.0 |
| 2568715 | 1972-09-01 | 933931 | 419224 | 28 | CASTILLA LA NUEVA | META | asesor_45 | punto_venta_16 | cluster_tienda_3 | categoria_macro_4 | categoria_9 | subcategoria_25 | producto_267 | No encontrado | 1.00 | 15.90 | 15.90 | 2.374272 | 0.693147 | 2.827314 | 2.827314 | -0.089444 | 34.193915 | 1.831206e+06 | 83.56 | 956065.0 | 0.471 | 1.000000 | 15.90000 | 15.900000 | 1 | 15.900000 | 1.000000 | 1 | 6.0 |
| 2568716 | 1972-09-01 | 933932 | 419225 | 46 | CURITI | SANTANDER | asesor_45 | punto_venta_16 | cluster_tienda_3 | categoria_macro_4 | categoria_9 | subcategoria_25 | producto_2690 | No encontrado | 1.00 | 20.46 | 20.46 | 3.335040 | 0.693147 | 3.066191 | 3.066191 | -0.040638 | 37.077072 | 1.801097e+06 | 86.88 | 1056184.0 | 0.501 | 1.000000 | 20.46000 | 20.460000 | 1 | 20.460000 | 1.000000 | 1 | 6.0 |
| 2568717 | 1972-09-01 | 933933 | 368060 | 57 | CURITI | SANTANDER | asesor_219 | punto_venta_15 | cluster_tienda_2 | categoria_macro_2 | categoria_5 | subcategoria_5 | producto_3200 | MULTICOLOR | 21.06 | 3.67 | 77.30 | 8.035200 | 3.093766 | 1.541159 | 4.360548 | 0.203878 | 37.077072 | 1.801097e+06 | 86.88 | 1056184.0 | 0.501 | 1144.450000 | 470.38000 | 0.411010 | 8 | 58.797500 | 143.056240 | 2 | 6.0 |
| 2568718 | 1972-09-01 | 933933 | 368060 | 57 | CURITI | SANTANDER | asesor_219 | punto_venta_15 | cluster_tienda_2 | categoria_macro_2 | categoria_5 | subcategoria_5 | producto_699 | GRIS | 17.01 | 3.04 | 51.72 | 5.377536 | 2.890927 | 1.396245 | 3.964995 | 0.064639 | 37.077072 | 1.801097e+06 | 86.88 | 1056184.0 | 0.501 | 1144.450000 | 470.38000 | 0.411010 | 8 | 58.797500 | 143.056240 | 2 | 6.0 |
| 2568719 | 1972-09-01 | 933933 | 368060 | 57 | CURITI | SANTANDER | asesor_219 | punto_venta_15 | cluster_tienda_2 | categoria_macro_2 | categoria_7 | subcategoria_5 | producto_3328 | MULTICOLOR | 45.50 | 2.73 | 124.03 | 11.021184 | 3.839452 | 1.316408 | 4.828554 | 0.362528 | 37.077072 | 1.801097e+06 | 86.88 | 1056184.0 | 0.501 | 1144.450000 | 470.38000 | 0.411010 | 8 | 58.797500 | 143.056240 | 2 | 6.0 |
| 2568720 | 1972-09-01 | 933934 | 78489 | 29 | CASTILLA LA NUEVA | META | asesor_45 | punto_venta_16 | cluster_tienda_3 | categoria_macro_2 | categoria_5 | subcategoria_5 | producto_4719 | BLANCO | 8.64 | 3.56 | 30.78 | 2.865024 | 2.265921 | 1.517323 | 3.458837 | -0.064583 | 34.193915 | 1.831206e+06 | 83.56 | 956065.0 | 0.471 | 569.240000 | 360.49002 | 0.633283 | 5 | 72.098010 | 113.848010 | 2 | 6.0 |
| 2568721 | 1972-09-01 | 933935 | 415279 | 42 | CASTILLA LA NUEVA | META | asesor_45 | punto_venta_16 | cluster_tienda_3 | categoria_macro_4 | categoria_10 | subcategoria_37 | producto_1414 | No encontrado | 1.00 | 33.04 | 33.04 | 3.753216 | 0.693147 | 3.527536 | 3.527536 | -0.019237 | 34.193915 | 1.831206e+06 | 83.56 | 956065.0 | 0.471 | 8.000000 | 100.30000 | 12.537500 | 3 | 33.433334 | 2.666667 | 1 | 6.0 |
| 2568722 | 1972-09-01 | 933936 | 419226 | 47 | NATAGAIMA | TOLIMA | asesor_45 | punto_venta_16 | cluster_tienda_3 | categoria_macro_2 | categoria_5 | subcategoria_5 | producto_511 | MARFIL | 11.52 | 3.75 | 43.14 | 4.485888 | 2.527327 | 1.558145 | 3.787366 | 0.018460 | 38.645737 | 1.550361e+06 | 80.70 | 770458.0 | 0.518 | 13.120001 | 48.23000 | 3.676067 | 1 | 48.230000 | 13.120001 | 1 | 0.0 |
| 2568723 | 1972-09-01 | 933936 | 419226 | 47 | NATAGAIMA | TOLIMA | asesor_45 | punto_venta_16 | cluster_tienda_3 | categoria_macro_2 | categoria_7 | subcategoria_5 | producto_248 | No encontrado | 1.60 | 3.18 | 5.09 | 0.452736 | 0.955511 | 1.430311 | 1.806648 | -0.184930 | 38.645737 | 1.550361e+06 | 80.70 | 770458.0 | 0.518 | 13.120001 | 48.23000 | 3.676067 | 1 | 48.230000 | 13.120001 | 1 | 0.0 |
Duplicate rows
Most frequently occurring
| fecha | pedido | id | edad | municipio | zona | asesor | punto de venta | cluster | categoria_macro | categoria | subcategoria | producto | color | cantidad | precio | valor | alineación con portafolio estratégico | log_cantidad | log_precio | log_valor | ajustada_alineacion | edad_promedio | ingreso_laboral_promedio | porcentaje_urbano | IPUG | GINI | total_productos | total_gasto | precio_promedio | num_pedidos | ticket_promedio | cantidad_promedio | categorias_diferentes | Total de edificaciones en obra | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1971-01-02 | 255243 | 148297 | 50 | ARGELIA | CAUCA | asesor_138 | punto_venta_21 | cluster_tienda_3 | categoria_macro_2 | categoria_3 | subcategoria_3 | producto_40 | No encontrado | 2.00 | 0.56 | 1.13 | 0.141696 | 1.098612 | 0.444686 | 0.756122 | -0.199980 | 36.84756 | 1.417426e+06 | 83.79 | 595819.0 | 0.512 | 509.88 | 903.490000 | 1.771966 | 14 | 64.534996 | 36.420000 | 4 | 0.0 | 2 |
| 1 | 1971-01-02 | 255243 | 148297 | 50 | ARGELIA | CAUCA | asesor_138 | punto_venta_21 | cluster_tienda_3 | categoria_macro_2 | categoria_3 | subcategoria_9 | producto_72 | GRIS | 150.00 | 0.13 | 19.84 | 2.495232 | 5.017280 | 0.122218 | 3.036874 | -0.083330 | 36.84756 | 1.417426e+06 | 83.79 | 595819.0 | 0.512 | 509.88 | 903.490000 | 1.771966 | 14 | 64.534996 | 36.420000 | 4 | 0.0 | 2 |
| 2 | 1971-01-02 | 255243 | 148297 | 50 | ARGELIA | CAUCA | asesor_138 | punto_venta_21 | cluster_tienda_3 | categoria_macro_2 | categoria_5 | subcategoria_5 | producto_919 | MARFIL | 17.55 | 4.04 | 70.96 | 8.449920 | 2.920470 | 1.617406 | 4.276110 | 0.225788 | 36.84756 | 1.417426e+06 | 83.79 | 595819.0 | 0.512 | 509.88 | 903.490000 | 1.771966 | 14 | 64.534996 | 36.420000 | 4 | 0.0 | 2 |
| 3 | 1971-01-02 | 255243 | 148297 | 50 | ARGELIA | CAUCA | asesor_138 | punto_venta_21 | cluster_tienda_3 | categoria_macro_4 | categoria_12 | subcategoria_14 | producto_221 | No encontrado | 1.00 | 43.91 | 43.91 | 4.565376 | 0.693147 | 3.804661 | 3.804661 | 0.022564 | 36.84756 | 1.417426e+06 | 83.79 | 595819.0 | 0.512 | 509.88 | 903.490000 | 1.771966 | 14 | 64.534996 | 36.420000 | 4 | 0.0 | 2 |
| 4 | 1971-01-02 | 256539 | 150249 | 39 | ARGELIA | CAUCA | asesor_93 | punto_venta_22 | cluster_tienda_3 | categoria_macro_2 | categoria_5 | subcategoria_5 | producto_423 | BLANCO | 24.30 | 4.13 | 100.27 | 11.937024 | 3.230804 | 1.635106 | 4.617790 | 0.411565 | 36.84756 | 1.417426e+06 | 83.79 | 595819.0 | 0.512 | 151.65 | 117.270000 | 0.773294 | 3 | 39.090000 | 50.550000 | 2 | 0.0 | 2 |
| 5 | 1971-01-02 | 256910 | 159910 | 43 | ARGELIA | CAUCA | asesor_111 | punto_venta_21 | cluster_tienda_3 | categoria_macro_4 | categoria_12 | subcategoria_14 | producto_221 | No encontrado | 1.00 | 43.91 | 43.91 | 4.565376 | 0.693147 | 3.804661 | 3.804661 | 0.022564 | 36.84756 | 1.417426e+06 | 83.79 | 595819.0 | 0.512 | 4.00 | 90.590000 | 22.647500 | 3 | 30.196665 | 1.333333 | 3 | 0.0 | 2 |
| 6 | 1971-01-02 | 256926 | 159910 | 43 | ARGELIA | CAUCA | asesor_111 | punto_venta_21 | cluster_tienda_3 | categoria_macro_2 | categoria_3 | subcategoria_3 | producto_112 | GRIS | 2.00 | 0.56 | 1.13 | 0.141696 | 1.098612 | 0.444686 | 0.756122 | -0.199980 | 36.84756 | 1.417426e+06 | 83.79 | 595819.0 | 0.512 | 4.00 | 90.590000 | 22.647500 | 3 | 30.196665 | 1.333333 | 3 | 0.0 | 2 |
| 7 | 1971-01-02 | 257202 | 160093 | 53 | ARGELIA | CAUCA | asesor_138 | punto_venta_21 | cluster_tienda_3 | categoria_macro_2 | categoria_3 | subcategoria_9 | producto_170 | GRIS | 75.00 | 0.44 | 33.31 | 4.866048 | 4.330733 | 0.364643 | 3.535437 | 0.038111 | 36.84756 | 1.417426e+06 | 83.79 | 595819.0 | 0.512 | 76.00 | 48.970000 | 0.644342 | 2 | 24.485000 | 38.000000 | 1 | 0.0 | 2 |
| 8 | 1971-01-02 | 257337 | 160166 | 38 | ARGELIA | CAUCA | asesor_91 | punto_venta_21 | cluster_tienda_3 | categoria_macro_4 | categoria_10 | subcategoria_37 | producto_1823 | No encontrado | 1.00 | 20.22 | 20.22 | 1.797120 | 0.693147 | 3.054944 | 3.054944 | -0.118474 | 36.84756 | 1.417426e+06 | 83.79 | 595819.0 | 0.512 | 2.00 | 28.449999 | 14.224999 | 1 | 28.449999 | 2.000000 | 1 | 0.0 | 2 |
| 9 | 1971-01-02 | 257337 | 160166 | 38 | ARGELIA | CAUCA | asesor_91 | punto_venta_21 | cluster_tienda_3 | categoria_macro_4 | categoria_9 | subcategoria_10 | producto_1218 | No encontrado | 1.00 | 8.23 | 8.23 | 0.321408 | 0.693147 | 2.222459 | 2.222459 | -0.191304 | 36.84756 | 1.417426e+06 | 83.79 | 595819.0 | 0.512 | 2.00 | 28.449999 | 14.224999 | 1 | 28.449999 | 2.000000 | 1 | 0.0 | 2 |